I have 5 xls files open. Each file has 10 sheets. Hcp.xls Efile.xls Rfile.xls Hfile.xls Wfile.xls
Hcp is the main file. I need to copy and paste ranges from the other 4 files into Hcp.

Efile copy range A1:CI22 paste to Hcp cell A250
Rfile copy range A1:AB1 paste to Hcp cell A278
Hfile copy range A1:CI221 paste to Hcp cell A288
Wfile copy range A1:W179 paste to Hcp cell B511

Sheet 1 data to Sheet 1. Sheet 2 to Sheet 2, Sheet 3 to Sheet 3, etc.


One macro/one click to transfer all data for all 4 files and all 10 sheets would be great. But if that is too much trouble; a macro for the Hfile that I can copy and adjust for the other files would be appreciated.

I really appreciate the help from the knowledgeable contributors in this forum. I have learned a lot. It has given me renewed energy on a 3 year project which I could not find help locally.
Thank you.