Extract data from specific cells and paste into a row

[Closed]
Report
Posts
1
Registration date
Tuesday August 23, 2016
Status
Member
Last seen
August 23, 2016
-
Our sales department has been using an Excel spreadsheet template to update product specifics, then printing it out and sending to our typesetting department to re-type. They've been doing it this way for YEARS and aren't gonna want to change. I can get them to email me the XL documents and I want to extract certain data cells to paste into rows so I can make a single csv file to merge into InDesign.
So if I have data in O9, H11, M13, M15, M17, D27, L27, and C35 (for instance) can I use a macro to extract that data and place it into B1, B2, B3, B4, B5, B6, B7, B8 of a new workbook? And then open (manually) the next sheet and do the same thing into the next row? And so on?
Can anyone provide me with a sample macro I can build on?
Best regards, Tim