Select Code to Download

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

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

...
  $row++;
  $col++;
}

    $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}          
+  );