Take a look at the Data/Consolidate method in XL Help.

In article ,
Jeff C wrote:

I have multiple identical worksheets with identical fields but each sheet
contains data for different time periods.

Is there a better way besides manually copy and pasting to a new sheet to
combine the data as you would similar to a union query?