Hi
I have a workbook with several Worksheets. I have created a Worksheet using a small Macro which list the Worksheet Names, now I want to retrieve data from each Workbook based on the Worksheet name. eg

Master Worksheet
A0001 (Select eg, Cell B2 from worksheet A0001, Cell B4 and Cell C6)
A0002 (Select eg, Cell B2 from worksheet A0002, Cell B4 and Cell C6)
A0003 etc (Select eg, Cell B2 from worksheet A0003, Cell B4 and Cell C6) etc
for all sheets.

Also is there anyway to do a Bulk Hyperlink from the Master Worksheet for the relevant Individual Sheets, without having to Individually Hyperlink each Cell.

Thanking you