Creating a Master Database with linked columsn

[Cogito13]

Hey guys,

My name is Grey, and I am new to this forum. I must say that you guys are doing some excellent work!

I am in sort of a pickle. I am working on creating a medical master database. I have a master sheet with a huge number of columns. I have a couple of guys working with me, and they have their own sheets in the workbook.

So here is what I would like to do: anytime one of the guys enters data into his respective worksheet, I want the data to be copied over to the master sheet in a new entry.

The columns among the worksheets are different, and I would like the data to automatically sort in the appropriate column on the master sheet when it is copied.

I have attached a copy of the workbook. Please let me know if you guys need any further clarification.

I have included an example of what I would like to see. For example, if Charles puts in an entry in his worksheet, a new entry is created on the master sheet with the information from Charles' sheet sorted in the appropriate columns.

Thanks!
Grey