How to get pivot table to draw from two sheets of data

[Becskters]

I have a large amount of data that I am trying to pull into one pivot - the data is in two sheets and is an extension of the same data with the same headings but even after I have copied the data into one sheet (with over 115000 lines!) it wont pull through the data correctly 

Can anyone help please?

Thanks so much 

[#2]

@Becskters 

Add worksheet data to a Data Model using a linked table

Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013

https://support.microsoft.com/en-us/office/add-worksheet-data-to-a-data-model-using-a-linked-table-d...

Also attached is a small file with an example.

Insert multiple data sources (worksheets) as a source with the PivotTable and PivotChart wizards. Unfortunately, it was banned from the menu ribbon at some point after XL 2003. However, it can still be activated today, depending on the Excel version. Customize it via the toolbar for quick access (right-click in the menu ribbon). Search for PivotTable and PivotChart Assistant under All Commands and transfer it to the toolbar.

Since you did not name your operating system and Office version, this is also possible with older versions. Since you did not name your operating system and Office version, this is also possible with older versions. I'm not sure whether the new versions have a different function or not.

With a possible activation it would look like this:

Old Pivot Option

Select the option marked in red and several tables can serve as a source.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.