Is this an one-time project? I.e. you get all data into single worksheet, and that's all. Further you use this workcheet, and previous ones are obsolete. When yes, then the simplest and fastest way will be:
1. Create a worksheet with table headers;
2. Copy data from 1st worksheet (except the header);
3. Paste the copied data into created sheet at 1st empty row;
Repeat p2. - p.3. for all worksheets you want to transfer data at;
When all data is transferred, delete old sheets.

When you want to keep the data entry on separate worksheets, and you want entered data automatically copied to summary sheet, then there is a question: Why?