Hi,
I am a scientist by profession with extensive experience in creating Excel-based templates for reformatting and applying calculations to complex datasets. I believe I should be able to create a template for you, using a combination of VBA coding and formulas, which will automate the reformatting of your data into the format you require.
I would need to see some example files from your suppliers, but it should be possible to create something whereby you import your source data (via a simple button on a 'Home' sheet) directly into the template. After this, it may be necessary for you to define the order in which the data appears on your source file (or this may be able to be automated, if it is reasonably consistent). The template will contain a 'Reformat' button, which will reformat your source data into the required format and export it as a separate .CSV file.
This method will benefit you in that you will not have to get in touch with anyone in order to process your data, you can simply use the template to do it yourself in a few seconds.
Please contact me if you would like to discuss the project further.
Thanks for your consideration,
Dan