Thank you both for the replies.

Basically I want it to automatically look at each sheet, pull the data out and place it in one big sheet. Does that make sense? For example:

Date, column 1, column 2, and so on.

I gave two sheets as examples to show how the data is the same on each page but the data does not start in the same cells. I would like it to it for every sheet in the workbook with the number of sheet around 30.