copy values from one to sheet to another - request

[jun22]

Dear experts,

I am looking for some help in creating a function/formula, which can automatically copy values from 'July' worksheet into the sheet2 by matching up the row1 headers to the worksheet names (i.e. July) and by matching up Column A and B's data between the sheets and extracting the values from sheet 'July' into 'sheet2.

I have attached an example file, showing the input data in July sheet and desired output in 'sheet2'.
data_extraction1.xlsx

Any help would be greatly appreciated.
Many Thanks

[watersev]

hi jun22, option