Multi sheets info transfer VBA (Excel 2003)

[Excelnoub]

http://www.mrexcel.com/forum/showthread.php?t=633913

Here is my workbook...

The explanation is also on MrExcel.

I would need help with this final VBA code.

If you insert information and go step by step you will see what I am trying do accomplish

[Excelnoub]

Workload Report 2012.xls

Replace attachment

[Excelnoub]

Anyone has any tricks I could search on ?

I tried the Concatenate and some vlookup but I can't use them. I need the code to run in the back ground and that user will not be able to delete it.

[Excelnoub]

Will do my best to explain the process of what is needed for the last code I need.

[Excelnoub]

Explanation of sheet1:

The user will start to insert the project number. This number will be transfer to the 5 first sheets. Other information will be directly transferred to sheet5 as Sheet5 is the report capture.

Once the user will have the sheet1's information inserted he will then clear the content by selecting "yes" in a drop down validation in cell H. This can be done between Rows 5 to 19.

The user will continue to add information in sheet2 until the process is complete. On the same line of the project. Lets call this project1. At the same time the user can have multiple projects at the same time. All project will not be on the same row but on the next available row. So the initial page for entry is Sheet1.

The user will continue to add info, depending on the project's life cycle.

Lets say we do an example with 3 project at the same.

Note: Information is transferred immediately after the user hits "Enter"

So Sheet1 will have:

A5= Project1 (Transferred to Sheet2, Sheet3, Sheet4 and Sheet5)
B5=Date (Transferred only to Sheet5)
C5=info (Transferred only to Sheet5)
D5=info (Transferred only to Sheet5)
E5=info (for User only)
F5=Info (Transferred only to Sheet5)
G5=Comments (This needs to be transferred to Sheet5 column P but in the same row as Project1's info)

Sheet2 will have

A5=Project1 (already transferred from Sheet1) no info or data needed
B,C and D5=dates (no info or data transferred needed)
E,F and G5= date (The 3 cells will be tranfered together on sheet5)
H5=Comments (This needs to be transferred to Sheet5 column P but in the same row as Project1's but after the comment from Sheet1)

Same will need this for Sheet3

D5=Comments (This needs to be transferred to Sheet5 column P but in the same row as Project1's but after the comment from Sheet1 and Sheet2)

____________________________________________

Project2 example:

If the user starts another project, lets say Project2, and is not ready to go on Sheet2, the user stops the process and goes on the the next project.

So in this example project2 is on hold on Sheet1.

____________________________________________

Project3 example:

The user has another project, so Project3 and this one continues all the way.

So you take example from Project1 and repete the process. The comments should never be the same.

Now project3 is in Cell A7.

I need when the user insert a comment in sheet1 is will be transferred in sheet5 after if the user inserts a comment in Sheet2 it will be transferred after sheet1's information but vs project3.

[Excelnoub]

Please Help me