Import data from multiple .mdb to multiple sheets

Hi all,

I want to update data from multiple .mdb files to multiple existing sheets at the same cell location, in one workbook.
All the .mdb files have the exact same format and I named them the same, "Raw".
My intended result is to update/match the data with the same file name and sheet name, i.e. A.mdb to Sheet A, B.mdb to Sheet B and etc.
I have a named range Range("FileName") where I listed down all the source files, so that the macro will loop for each name in the list.

Below is the current code that I have:

Please Login or Register  to view this content.

I got an error and I think it's because the destination sheet name cannot be recognised (dim as range).
Appreciate if anyone can assist.

Thank you.

Hi TMS,

Thank you for your reply.

Never thought that a small trick will do the magic!

Thanks!