How to make a pivot table using 2021.xls and 2022.xls

Hello,

I have a following problem. Some of our production data is still on excel tables. Data from each year is stored to distinct files e.g. Prod_data_2021.xls and Prod_data_2022.xls.

At the turn of the year I always have the same problem when I need to update trend graphs for last ~15 weeks and the actual data is stored to different files.

The data structure (columns) are same for both files, lets say: column A = date, column B = site, column C = paid hours, column D = output. 2021 file contains +30,000 rows while some hundred rows are added to the new file each day.

I would like to make a pivot table that would take the data from both of these files, but haven's succeeded. The output I am looking for is very simple, maybe the solution is too if you know what you are doing. I only need continuum for data and output preferably in a pivot table. How would you solve it?

Site ABC
...
Week 51: 210 pcs/h
Week 52: 225 pcs/h
Week 01: 220 pcs/h
Week 02: 215 pcs/h

Site DEF
...

Thank you! Your first suggestion solved my problem. Tried the second one too, but I couldn't make that work as it demanded unique identifier. Maybe I did something wrong there.