Copy rows from multiple sheets in one workbook into a different workbook

[maneeshagr]

Hello,

I have a workbook that contains multiple sheets where we enter data on a weekly basis.
The columns are the same in all the sheets. However, the rows containing data will be different in the sheets.
For example, the first sheet may have data in 10 rows, second in 5 rows and so on. This can keep increasing as we keep entering data
I would like to consolidate all the multiple sheets into a different workbook- Master Workbook that would contain the rows containing data from each of the sheets.
Once I have copied for the first time into the Master Workbook, would like to just keep updating the 'Master' workbook as and when data is entered in the original workbook.

Please advice.

[arlu1201]

It will be good if you attach a sample workbook. Also, is it fine if i use a hidden column to put in a tick mark or any identifier to show that the row has been copied?