Extracting Same Column from Many Spreadsheets

[ablackout]

Hi,

I'm downloading a report generated in Excel, and I have a macro that rearranges the data in each one. However, I still have to manually copy and paste the row into my main spreadsheet.

Is there an easy way to either set up a macro or use VBA where I can extract the row in question and add it to an existing spreadsheet? The row will always be the same number.

Thanks in Advance.