Copy Sheets 2-5 from several worbbooks

[howard]

I have 5 workbooks where I want to copy the data from sheets 2-5 for same row header (which are in row 4) one below the other where the row headers are the same for eg Sales Shirts must all be copied one below the other where the row header in row 4 contains the same header for eg Sale Shirts, sale trousers etc


I want the info to be copied on to from sheet 2 onto sheet1 , sheet 3 on to sheet 2 from etc on row 1 onwards on the destination workbook



Your assistance in this regard is most appreciated