Hi

I have a workbook with several people, each with their own tab plus a 'data' tab, eg, Person1, Person1_Data, Person2, Person2_Data etc etc. I have a PT on each person tab which looks at data on the corresponding 'Data' tab. I also have the tab name in A1 of each person tab.

What I am trying to do is dynamically change the data source of the PT by using a named range. When I define that Named Range I am using:

=INDIRECT("'"&"$A$1"&"_Data'!"&"$A$3:$G$3000")

I am getting 'reference is not valid'

The reason I am trying to do it this way is because I will be adding more tabs (users) and I don't want to have to manually change the data source each time.

Any help would be appreciated.

Andi