VBA Combining Data from multiple Workbooks

Hi,

I found a vba script online that would gather data from multiple worksheets located in one directory/folder and have the same number of columns and layout as my master spreadsheet hosting the vba code and all the data. The issue is that I would like the code to also add a column with the name of the file (workbook) the data in that line was extracted from.

Can anyone please have a look at the code and send me a revised code with the above addition?

Thank you very much!!!

Below is the code I currently have:

Please Login or Register  to view this content.

Would the formula "=CELL("filename";anyCellReference)" help if you include it in your code?

JBeaucaire, the problem was that I did not add "\" to the end of the directory. I just fixed that. The problem I am getting now is:
When I run the code, I receive "Run Tim e Error 438 "object doesn't support this property or method".
When I click "Debug", it says "can't execute code in break mode". When I click "Debug" again, the following row is highlighted in the code:

Please Login or Register  to view this content.

JBeaucaire, Thank you so much! It works wonderfully!

my pleasure! please mark your question as "solved"