Input Data on Master Sheet based on Sheet Name

**enna1949** · 01-08-2013, 10:42 PM

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

**jeversf** · 01-09-2013, 03:33 PM

Hi enna

Please see attached for a possible solution. By using the drop down box you can tell the indirect formula which sheet to reference, all you need to do after that is change the 'lookup' cell reference in the formula.

Hope this helps!

search worksheets.xlsx