Hello i have three files:

Appendix 1.xls
Appendix 2.xls
Appendix 3.xls

And in each file i want the cell range from a9-g18 to be copied (so appendix 1,2 and 3 i want them cells copied)

anbd pasted in copy1.xls as one sheet all under each other with one line gap?

any ideas?

thanks