Manipulating multiple worksheets is made easy with our latest pivot table tutorial from pivot king David Carter.

His latest guide - Consolidating multiple worksheets in a Pivot Table - to this invaluable Excel tool should take only 15 minutes, and shows you how to take a number of worksheets and turn them into one comprehensive spreadsheet.

Carter's new tutorial comes in response to a question from AccountingWEB reader Tom Trainer, who wanted to know if pivot tables could be used to manipulate 3-D spreadsheets - the answer is yes, says Carter, as he shows how to use pivot tables to produce a variety of views of the data.

This top pivot table tip is an adapted version of a tutorial first published by John Lacher, an American CPA.

* New to pivot tables? David Carter's series of award-winning pivot table tutorials on AccountingWEB have become an Internet legend. Visit our overview of Carter's pivot table tips - a must for anyone who regularly uses Microsoft's Excel spreadsheet program.

View more helpful tips!