Index across multiple sheets - or a better way (please)

I have 20 sheets in one workbook all set-up identically that I'm using for source details and from it I need to identify basic information. I have set-up a 21st sheet to provide me with a min rate from within the other sheets which I'm getting - but now need to identify where that rate came from either from the sheet name or from cell a1 in each sheet. Can you advise best way to get this info?

excel help.jpg
Nick's picture

hi Maria... any reason why

hi Maria...
any reason why you are not using a pivot table ?

No reason

Honestly didn't think of that - prob cause I haven't used them much (not proficient at them). Open to suggestions...