populate data from multiple sheets and any new sheets added onto a summary sheet

Hi everyone - I am trying to populate a summary sheet with data from multiple sheets in a workbook and the summary needs to automatically populate as new sheets are added by a user other than me. I don't want to SUM the data. I want to list the data in columns to match the data found in the other sheets. My sheets have the same template so cell references will always match. My columns are named: Project ID; Project Name; Accounting #; Estimated Completion. Each of the sheets has the corresponding field in the same location on each sheet. Thanks...