hi, another hyperlink question

i have a column of 20 hyperlinks on a single excel sheet, which needs to be clicked by macro one by one. once the csv file is downloaded/opened (done automatically when link is clicked), then it needs to move/transfer the tab with data contents to another workbook, one for all 20, and rename the tab to "A" variable (i.e data tab 1 = name from cell A3, data tab 2 = name from cell A4 etc)

=HYPERLINK("http://something.com/data.csv?s="&A3&"&d="&I3&"&e="&J3&"&f="&K3&"&g=d&a="&F3&"&b="&G3&"&c="&H3&"&true=.csv")



could anybody give me vba code that will do this job please


i tried to do it simpler way, below, however one of the variables that needs constantly changing (namely column A) comes up as fixed everytime macro is run (i.e if all 20 variable changed, i have to physically need to change the code one by one for all 20)

Workbooks.Open Filename:= _
=HYPERLINK("http://something.com/data.csv?s="&A3&"&d="&I3&"&e="&J3&"&f="&K3&"&g=d&a="&F3&"&b="&G3&"&c="&H3&"&true=.csv")



any help would be greatly appreciated