Excel 2003 Macro - Split data in two worksheets and place in a individual workbook

Hi wonder if anyone can help me with a macro I have a template workbook and need to open the Item - Header workbook which contains data place the data into the template one then save it as a certain file name then loop to get the next set of data and so on any help would be grateful thank you in advance

HTML Code: