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

Occasional Visitor

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 

 

1 Reply

@Becskters 

 

Add worksheet data to a Data Model using a linked table