populating master spreadsheet from several feeder spreadsheets

Hi, my knowledge of Excel is basic as I haven't really used it for several years.

I need help with creating a master spreadsheet that is auto populated via several feeder sheets in the same workbook. the feeder sheets will always be the same and have the same column headings, each sheet will be for a different employee. Typical headings will be client name, manager name, pay, charge etc.

However, on the master sheet i'd like it to automatically populate on the next available row below, regardless of which feeder sheet I have entered the data in to.

E.g. i might enter data in row b on feeder sheet 2 = want that to populate row a on master sheet.
then I enter data in row b on feeder sheet 4 = want that to populate row b on master sheet

Is this possible, and can anyone help?

Thanks,

Roheel

yes please