foreach my $link ( @links ) { 
  my $url = "q{internal:'$link'!A1}";

  $worksheet1->write_url ( $row,$col, $url,$label );
  $row++;
  $col++;
}

##</code><code>##

foreach my $link ( @links ) { 
  my $url = "internal:'$link'!A1";

  $worksheet1->write_url ( $row,$col, $url,$label );
  $row++;
  $col++;
}
##</code><code>##

    $worksheet->write_url('A6',  'internal:Sheet2!A1'                   );
    $worksheet->write_url('A7',  'internal:Sheet2!A1',   $format        );
    $worksheet->write_url('A8',  'internal:Sheet2!A1:B2'                );
    $worksheet->write_url('A9',  q{internal:'Sales Data'!A1}            );