Raw Data Transfer Between Sheets, 2003, Windows XP Pro

Where I work there is a file that we have to submit to management every Friday. This is a raw data file to be imported into another system. With 7 different employees accessing the same passworded file on a network drive, we have had some errors in the external program due to input typos.

I have created a worksheet for employees to input weekly data, ie workorder number, hours worked, etc. all in a neat and defined order. I have also added nested if formulas to validate data length and duplication within a group.

Now I need to transfer just the raw data from the employee entry sheet to a seperate sheet, reformated in the raw data format. This requires copying common data for all workorders worked. I can provide more data examples from work.

I would prefer that the data copy and reformat be done with formulas as the parent company frowns on excl macro's, especially unsigned.

I have 15 rows available to the employee each day to input. One of the problems I have ran across is the raw data format cannot have blank rows or rows with missing data.