Automated Data Output For Product Insertion Into Shopify

I need a macro written to rearrange data supplied from the input of an excel csv file which will produce a specific set of output excel workbooks for import into a shopify website. I can do this myself manually and step by step but I need a macro written to speed up the steps so they can be applied to new data updates regularly. You must have a knowledge of pivot tables to do this and also extracting specific rows from a workbook to another workbook. The completed workbook should have a button in the beginning worksheet to manually select the input data file and generate the desired output workbooks. (approximately 35 differents workbooks) there are 45000 rows to parse in the real input file. Sample files are supplied.