To transfer data from one sheet to another four sheets and also to pick up the higher pric

Dear All,

I have 10 wks in the attached workbook, namely:
1. 1) ICU
2. 1) GW
3. 1) Inpatient
4. 1.1) Consolidation
5. 1.2) PT – Consol
6. 2) Usage
7. 3) Consum.
8. 3) Drugs 1
9. 3) Drugs 2
10. 3) Drugs 3

and what I would like to achieve is, the final results to be displayed in those last four wks (wks 7-9).
For wks 1-3, the code, description and prices are provided by each dept and the details inputted are varied even though it is for the same item.
When all these come to me, I try to standardize all the items by giving it a ‘Final Name’ as shown in Col F in wks 4. Then I use pivot table to tidy up the data (wks 5).
When it comes to billing, a patient’s usage will be summarize in wks 6 by a clerk and ultimately transferred to wks 7-10 manually by another clerk. As a result, it is always prone to human mistakes. Like the quantity miscalculated, entered into wrong column or cell, etc.
Would someone kindly provide me with VBA code that
1) the data can be transferred from wks 6 to wks 7-10 automatically?
2) Will take up the highest price from wks 5 and display in wks 7-10?

Thank you so much for your constructive input.

Sorry, if i dont misunderstand you, i believe you mean 'wks'? It is for 'worksheet'. wks 5 means the 5th worksheet, ie. 1.2) PT - consol

For your info, i just posted the same question in another forum

http://www.vbaexpress.com/forum/showthread.php?t=44339