Consolidation of selected worksheet from several workbooks
 

I have a 'master' file in which I want to have a worksheet containing a
2-column list of filenames and worksheet names which I want to copy all the
named worksheets into the 'master' file

For example,

[path] File1 v01.xls SheetXX
[path] File2 v01.xls SheetYY
[path] File2 v01.xls SheetZZ
[path] File3 v02.xls SheetAA

so I want to copy SheetXX from File 1 v01.xls into the Master file as
SheetXX, then SheetYY from File 2 v01.xls, etc, etc

the number, and names of the files will vary, but the worksheet names will
be unique, and in some cases I will want to select more than one sheet from a
workbook.

Each or the worksheets to be copied has certain rangenames, which I want to
preserve in the Master file. Also SheetXX my have a formula which references
a worksheet called "Rates" which will exist in all files, and I want to
ensure that when the sheet is copied into the Master file, the formula points
to "Rates" in the Master file and not the source file

Any help would be gratefully appreciated.

Thanks