Copy data from multiple sheets into one

[aggiemarine07]

Howdy! Ive seen elsewhere on the forum, notably here and here, that show what I want to do but for the life of me I cant adjust the code to get it work correctly.

I have 6 total sheets (Sheet2 through Sheet 7) that have the same column headers and data on each sheet (A6:J). I want to copy this data from these sheets and put it into a "Summary" sheet (Sheet1).

From here I want it to sort the data based on two criteria (Date and Time from the column headers; Columns A and C) moving all the rows with no data in Column E to the bottom.

Any help with this would be greatly appreciated! Thanks!

 

[ztodd]

Headers are in row 6 on every sheet?
Can it be assumed that every row to be copied has a value in column A? (For the purpose of knowing which is the last row in each sheet)
Should Sheet1 be cleared out (all data rows deleted) before copying all other sheets to it?

 

[aggiemarine07]

Headers are in row 5 of each sheet, the data starts in row 6.

Yes there is a value in Column A and can be used to determine the last value, also Sheet 1 can e cleared out before copying.

 

[ztodd]

working on it- can you post the latest code that you have already tried?