I have a performance spreadsheet containing multiple worksheets, each
worksheet holds performance data for an individual fund. Each of these
funds has its own spreadsheet containing static information about the
fund.

I need macro that will copy the performance data from the performance
spreadsheet to each individual fund spreadsheet. The cells to be copied
are the same for each worksheet (B2:D65).

Each worksheet in the performance spreadsheet is named with a fund
code, this fund code is also the name of the respective worksheet in
each fund spreadsheet.

I need the macro to copy cells B2:D65 from each worksheet where the
performance spreadsheet.worksheet name = fund spreadsheet.worksheet
name. All the fund spreadsheets reside in the one directory. Thereofre
the macro must match on worksheet names within each spreadsheet.

Thanks!
Steve