Merging data from 7 worksheets into 1 pivot

Hey,

I have seven worksheets within on of my excel spreadsheets. Within each worksheet i have several columns and i am seeking to summarise the data of all the worksheets into one pivot table to report back to individuals with, as it will provide a good 'overview'.

so i.e. each worksheet is titled with a name say, A, B, C, D, E, F, G. within each worksheet there are several currencies i.e. USD, EUR, GBP, JPY etc and then there is a column highlighting 'total' for each currency, and then 'unexplained differences'. and ideally I want once pivot table to summarise this info for each of the worksheets.

So, the pivot would show, the worksheet name, the total for each currency split and the remaining unexplained differences.

This a tricky one any help on this guys would be really appreciated....

Thanks in advance for the help.

Jay