Hi

Rather than copying the Pivot table to each individual workbook, could
you copy the data from each workbook to a single workbook.
Obviously, only copy the header row for the first one, then the data
from each subsequent one below.
Perform the Pivot on this one consolidated set of data.

--
Regards

Roger Govier


"sas" wrote in message
...
I am still having trouble copying a Pivot Table from one workbook to
another
and having it to be relevant to the workbook I am copying it to. I
have
also tried using the Macros function by copying the steps in making
the Pivot
Tables for each day of the week that I am trying to extract info from,
but as
soon as I tried running the Macros on the other workbook, it gave me a
message error window that said something about debugging.
I have a project in which I have alot of time sheet workbooks per
employee
that I need to extract the the amount of time each employee spends on
a
particular "task".
It is taking me forever to do them individually. Does anyone have any
ideas
as to how I would do this?