extracting data to csv from multiple worksheets

[sjharri]

I have a spreadsheet containing fund and benchmark performance data
over a fiver year period (60months). There are a number of funds
(approx 20), each stored on individual worksheets with the fund
shortname as the worksheet name.

I need to write a macro that will extract all of this data and insert
it into one large csv file which will then be imported into a sql
server table. The number of periods(months) and dates are excatly the
same for each fund and therefore the cell range to be extracted are
also the same across each worksheet (A565). The first cell on each
worksheet also contains the fund shortname.

Questions are:

1. How can extract cells A565 from each worksheet into one large
xlcsv file?
2. For each fund added I need to add the fund shortname as the first
column for each period (month). The fund shortname is currently stored
in cell A1 on each worksheet.

I am a complete novice at this so I hope this makes sense.

Thanks
Steve