Data manipulation from one worksheet to another

[beacon]

Hi,

I'm trying to create a workbook that has a master worksheet and 8 subworksheets. Other users will enter information into one of the 8 subworksheets and I'm wanting that data to copy into the master worksheet. The thing I can't figure out is how to tell the subworksheet to place the copied info into a new row of cells when the users exits the cell.

Here's an example:

Master
Subs - a, b, c, d, e, f, g, h

A user enters a name, date, and time into sub a. This should cause the Master to copy the data into a new row of cells. That way, if data is entered into sub b, the data in the cells for sub a don't get erased.

Thanks for the help,
beacon

[protonLeah]

In general, you need to divide your master sheet into eight areas where the data from the secondary sheets will be copied. The formula

=Sheet2!A1

placed in a cell on any other sheet will copy the contents of Sheet2, cell A1 to any other sheet.

[beacon]

Thanks for the reply proton, but that's exactly what I'm trying to find a workaround for. The workbook will have to stay the way it is right now with 1 master worksheet and 8 other worksheets. The 8 other worksheets look just like the master sheet and will only copy the data from their location to the master worksheet.

This is for patient admissions info from various other hospitals to be collected by our hospital when one of the other hospitals schedules an admission/transfer to our facility.

I'm mostly just trying to figure out if there's code that could be written to tell the master worksheet to copy the data from the other worksheets on a new row without deleting other data. I can't specify which cell or row the data will go to because I won't know at the time of entry.

Thanks,
beacon