Create pivot table from data of several combined Google sheets

Job ID: 31693458

Budget: ₹1,500 – ₹12,500 INR

I want to create
1.pivot table from several google sheets with data over 5 million cells.
2.Add more sheets of data every month
3.Join google sheet data for every month with the datas which are already joined previously as per point1
4.connect the joined data in google sheet with pivot table