Separating records by relocating cells

Hello All,


I need to automate the following process:

I've an excel worksheet that is (columns x rows) 19 x 260 size, arranged as follows;

ITEM CODE ITEM DESCRIPTION Package Manufacturer Model Dimensions (mm)
_________________________________________________________________________________________________
ANAPH64 Blood Gas, MF Siemens Rapidpoint 90 x 80 x 150


Mounting Type Weight Heat Gain Power Volt Current Power Source Phase Remarks
________________________________________________________________________________________________
Wall fixed 15 Kgs 854 264 230 1 Normal 1 N/A


Data Port QTY Plumbing Connection Pressure
_________________________________________________________
Data Port 1 Drain 2.5 inch 90


I put it here on 3 parts due to limited space.
I need to do two main actions:
First, to automatically create a separate worksheet for each item code, and name the worksheet using the item code, so that I'll end up with a 260 newly created worksheets.
Second, each worksheet of those just created will have a form (already designed) to have same headings as above BUT in different distribution, and it looks like a template page or a one-page report to summarize specs of each item.
Hope my language is clear.
I tried to take a screen shot and paste here to show clearly what I mean, but I couldn't do that.


Thanks so much...
Heahn