Using Excel 2003
My PivotTable is set up as follows:

RESOURCE NAME TASK NAME HOURS WORKED
name1 task1 ##
task2 ##
task3 ##
name2 task1 ##
task2 ##
ect...

My 'report' I'm running off of this data is set up as follows:

HOURS WORKED
ACTUAL HOURS
RESOURCE NAME TASK NAME PREDICTION WORKED
name1 task1 ##
##(from pivot)
task2 ##
##(from pivot)
task3 ##
##(from pivot)
name2 task1 ##
##(from pivot)
task2 ##
##(from pivot)
(want to pull this
column from Pivot Table)

My question is: Is there a way to pull the task names, that fall under the
resource names, with something like a GetPivotData function? The resource
names stay consistant, but tasks are constantly added/subtracted and I would
like to use a getpivotdata function(or something similiar to this) to keep my
reports list up to date as the PivotTable is updated- rather than manually
enter all this. I have used the GetPivotData function, but can only get it
to pull the task1 that is on the same line as name1. I understand this just
may not be possible but it's worth a shot to see if any excel masters out
there have any ideas for me.

Thanks in advance for any help.