Another possibility:

Union Query Macro -- Sheets in One File

Instead of manually setting up a union query, you can use the code in a sample file from Excel MVPs, Kirill Lapin (KL), with amendments by Hector Miguel Orozco Diaz

at the below link:

http://www.contextures.com/xlPivot08.html

(About 5/6 down the page)