Macro Merge Data from Multiple Excel Workbooks --- Stock Data

[jonathonappleseed]

Hello,

I have downloaded a large quantity of NYSE data & would like to create a macro that allows me to compile summaries of a stock's history. The workbooks are separated by day, with each book listing the end of day data for every stock on the exchange (see below for exact format).

Symbol

Date

Open

High

Low

Close

Volume

<tbody>
</tbody>

I need to create a summary for several specific stocks (preferably without having to open each file individually, search the symbol, & copy/paste the data into a summary). The format for the final summary workbook is:

Date

Open

High

Low

Close

Volume

<tbody>
</tbody>

Any advice? Thank you!

 

[jonathonappleseed]

I found another data set that has this format. If anyone is interested, you can go to:

[url]http://www.google.com/finance/historical?output=csv&q={symbol}[/URL]

& download 1 year of stock data with the same format listed as above. Thanks anyway.