Hi degross,
In older versions of excel (like 2003) you have a chance. See:
https://www.techbout.com/pivot-table...rksheets-4974/
I remember this is somewhat limited in all the things you can do and I'd simply copy and paste the data to a single table on a 5th sheet, but give the link a try.
Hope this helps.
Bookmarks