Do some data entry

I have a data analysis task. I am having a balance sheet with all data entered in different tabs of spreadsheet for all the quarters. Seperate tab for each quarter. I wanna to generate 4 new tabs which generate reconciliation output for the same quarter across the last 5yrs. So for example new tab should genereate reconciliation result for Q1 of 2012,13,14,15,16. So same way another 3 tabs will show reconcile results for subsequent quarters.