Extract Data from newly created Excel files to an update file

Hi,
This is a humble request for any/all assistance I can get, with the following task...
I would like to automate the extraction of data from all new excel files created in a certain directory.
The data must be copied to an updated excel file to the corresponding columns.

Details are as follows...

New "Quote" Files are created in a specific directory. ( C:\TGL Diary\Quotes\ )
File names have the format "2861 Client Name.xlsx" where the number portion is incremented with each new quote created and also the Client Name changes.
File to be updated resides in a separate directory. ( C:\TGL Diary\Bookings\Updates.xlsx)
Specific Data to be extracted from "Quote" Files always located in cells...
$M$5 - Quote Date:
$M$6 - Quote No:
$B$13:$B$20 - Client Details:
$J$13:$J$20 - Accommodation Details:

Corresponding columns in Update File to be updated ... Columns B to J

Any assistance in this regard will be greatly appreciated.

Kind Regards
Dean

Hello @DEANH123. Can write macro code for your needs, But. You need to reconsider the source file structure. Namely, these are the merged cells, they are the ones who complicate everything and scare away those who help on this forum. Change the structure of the file and fill it with data, attach it to the post, and then they will definitely help you write the code. Good luck.
P.S. Sorry for my English.

Possibly...

Please Login or Register  to view this content.

Copy this code into a standard module in the Updates file.