Pivot Tables in Excel - reorganising rather than analyzing data

Hello

We use Cascade HR software which allows me to set up queries on our staff data and pull them into a report which then downloads to an Excel file.

I can then use pivot tables to rearrange the data as I want, and reupload the Excel sheet, so that all subsequent reports will copy the new format.

At the moment, the raw data (which I have to keep in tact and use), is split out by query, eg New Starters, Leavers, Promotions etc etc, so there is a tab per each query. But I want the tabs split out by location.

So, I need to do a pivot table for each worksheet (I can't collate the data first...) to somehow get the data reorganised.

I know Pivots are usually used to analyse rather than reorganise. I don't want counts or sums. I just want the data collated and re-split out in a different way.

Is this possible? And can you offer some help on how I go about it?

Thanks

Gem.