Copy date from Single Input to Multiple Workbooks

[noront]

I am creating a workbook for asset history where each asset has its own worksheet. This is continually updated as assets are utilized.<o></o>
For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code that will copy the header data along with the values associated with the specific asset to its specific page. <o></o>




The worksheet name will be the asset id [TABLE="width: 530"]
<tbody>[TR]
[TD="width: 82, bgcolor: #595959"]Job #
[/TD]
[TD="width: 110, bgcolor: transparent"]12AB
[/TD]
[TD="width: 105, bgcolor: #595959"]Date
[/TD]
[TD="width: 75, bgcolor: transparent"]Dec
[/TD]
[TD="width: 97, bgcolor: #595959"]Location
[/TD]
[TD="width: 55, bgcolor: transparent"]There
[/TD]
[TD="width: 169, bgcolor: #595959"][/TD]
[/TR]
[TR]
[TD="bgcolor: #595959"]Operator
[/TD]
[TD="bgcolor: transparent"]Jack
[/TD]
[TD="bgcolor: #595959"]Operator 2
[/TD]
[TD="bgcolor: transparent"]John
[/TD]
[TD="bgcolor: #595959"]Client
[/TD]
[TD="bgcolor: transparent"]Him
[/TD]
[/TR]
[TR]
[TD="width: 82"]Asset ID
[/TD]
[TD="width: 110"]Usage 1
[/TD]
[TD="width: 105"]Usage 2
[/TD]
[TD="width: 75"]Value 1
[/TD]
[TD="width: 97"]Value 2
[/TD]
[TD="width: 55"]Val 3
[/TD]
[TD="width: 169"]Comments
[/TD]
[/TR]
[TR]
[TD]12345
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]23456
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]34567
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]