Tab names used in pivot table.

[lweidt]

I am trying to make a pivot table summarising training received of 24 people. I have a worksheet with each individuals training on a separate tab (so I can search by each person individually) but I also wish to condense this into a table which displays the training and who received it (so I can search by specific training). Is there a way of the pivot table recognising the tab names so that this data can also be used (perhaps instead of the page item headings)?

I basically want a list of all the different training followed by the names of those people who have completed it. The reason I was using a pivot table is because I would also like it to update itself as people complete more training.

Any help would be greatly appreciated.

[JosephP]

I suggest you put all the data on one sheet and just use filters when you want to look at one person's data. it will make your pivot table and other reporting a lot easier