Dynamically change Table name in Formula based on cell reference

Morning Everyone...again! Second Post of the Morning!

I have a Sheet called 'MASTER SHEET', and in Column A (from Row 4 Downward) I have a list of names.

I then have a sheet for each of those names (named the same as the cell - so they match exactly) - and on each of those sheets there is an identical table (in terms of columns), and the table is named exactly the same too.

i.e. if Cell A4 on 'MASTER SHEET' says 'Chris' then there is a sheet called 'Chris' and also a table within that sheet called 'Chris'.

What I'm trying to do is have a formula i can drag down the column that looks at the name in Column A - to dynamically change the table it looks at?

I'm also trying to do this without using 'INDIRECT' as seems so memory hungry and refreshes constantly...

I would have attached template; but has loads of links to the web and wasn't sure if people would want this!



Chris

Sorry - forgot example formula...

One of them is as follows:

Please Login or Register  to view this content.

Then i'd just want the bit that says 'Torres' to change to whatever the contents of a cell in Column A on 'MASTER SHEET' is.

Hope this helps!



Chris