Merging two (or more) tables with Power Pivot to create one sheet with all data

Hello all,
This is a rather simple question but suprisingly couldn't find an answer thus far.

I have an excel file with several sheets. Each sheet has a lot of raw data, different variables in each sheet, though there is one (sometimes more) "key" (a product SKU for example).

All I want to accomplish is to have one excel sheet with all of the columns and variables combined.
What's easy to accomplish is to have a pivot table with all the variables - but that's not what I want. I don't want the aggregate/calculated values in a pivot table - I just want to have one sheet with all the data put together, to be analyzed somewhere else.

Can anyone help?

Thanks!

I have done something similar, but the solution I used was primitive.

Give that Excel letss you have 1m+ rows of data, say your 3 spreadsheets are roughly 1,000 rows long, then on the "Consolidated" spreadsheet, allocate rows 2:10,000 to link to sheet1, rows 10,001:20,000 to link to sheet2 and 20,001:30,000 to sheet 3. You have still only used 3% of Excel's row capabilities so plenty of room to expand this if you need to. Row 1 has the column headings.

Now you can run a Pivot off the "Consolidated" sheet.

Any good?

that's not what i need. sorry for not explaining myself better.
I don't want a pivot.
I want one sheet with all the data together, all the data columns one by another, merged / mashed together / consolidated using the key.