Automating a process for consolidating rows of data from several tabs into one summary tab in an Excel workbook on an ongoing basis

My spreadsheet has multiple identical tabs, one for each of 10 users. Each user is to populate each row of their tab (Columns A through G) with their own (unique) work orders, in the order they are received. All tabs are identical in terms of the number of columns and the column headings.

I need to find the best, most automated process, to:

1. Copy the populated rows from each of the 10 user tabs into a summary tab called "LU_Workflow" that resides in the same workbook
2. For Column H in each user tab to automatically populate with the date that the work order was copied into the summary tab

These user tabs would have new entries every day on an ongoing basis. I would like to be able to control the timing of when this automated process occurs.

I have included a sample spreadsheet to illustrate what I am looking for.

I hope I have explained this clearly enough. Please let me know if you have any questions.

Thanks!
Andrea
EE_MergingRows.xlsx