Using a macro to automatically gather a large amount of data

I'm using a spreadsheet containing a macro that pulls stock data from a website. You enter the ticker symbol and it pulls up historical performance information. If I want to do this for a lot of stocks (50+), how could I do this quickly? I want to be able to copy the data into another spreadsheet.