Hi

Currently the problem is:

1) I have a varied amount of worksheets. Anything from 1 to 80.
2) On a Summary Worksheet I have table that looks like:

Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Jan
Feb
Mar
Apr
Etc

Column A, months can be anything.

Each worksheet tab is named using the same convention as the worksheet tab,
so there could be a worksheet called Jan, Feb or Mar.


I need to contruct a Vlookup that looks on the relevent worksheet tab and
and looks for the heading of the data item on the first row of the summary
sheet and returns the matching item to the summary sheet.

I have used indirect, Address before but canont seem to get any further. Any
ideas.

I do not want to use VBA, only Excel Functions.

Regards