I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.

I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside
a workbook.

Then on each of 6 other tabs, I need to reproduce the same sheet, with
the exception being that sheet 2 needs to be for user 2 and sheet 3
needs to be for user 3. Either that, or I need to do it in reverse
order - where a user would update sheet 2,3 & 4 and sheet 1 is a
compiled list of those entries, one after the other.

The second option, of the two, would be the preferable, as that's
similar to how they do it now (with the exception of the "master" sheet
of all the orders).

Anyone know how to do this? (specifically the adding of a new record to
sheet one from the 6 other sheets in the workbook).

Thanks,

BC