VBS Macro to Reformat Data For Import

Hi,

Where I work, we receive spreadsheets that come formatted in a certain way. I have to take these spreadsheets and manually go through each one to put them in a different format to import in to our system. I know there has to be an easier way to do this using VBS in Excel. I'm terrible with VBS so I was wondering if someone could help me. I know from a previous VBS macro that I received help with that I can have it run a File Open dialog box and select multiple files. I would like a macro to allow me to select multiple excel files and have it take each entry from the spreadsheets and place them in the formatted spreadsheet. This would make my import process not so much of a headache as it has been in the past.

I've attached a sample of the data file and a sample of what I would like the final results to be.

Thanks for any help in advance.