Extract data from specific cells and paste into a row

Registration date
Tuesday August 23, 2016
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