Hi, I wonder whether someone may be able to help me please.
Firstly, I'd like to apologise because my VB is not my strongest subject, so to some this may be a very basic error.
From a tutorial I've found, I've adapted the code (below) to allow the user to copy from multiple Excel files...