VBA copy only newly added data, from folder to file

Hi,

we have approx 50 to 200 csv files in the following folder

path is
D:\New folder (4)

We are copying data (data from Column A to Column N) from all the work book to a master workbook

We have added a filter, we are filter the data "ET" in column B

in all workbook there is only one sheet and sheet name is same to file name.

Example
Copy Data from one file to master file, Data copies and rows occupied A1 to N500
Now again we are copying data and this time data will be paste on A501

we are doing this with the following code and just want that when we add new csv file in folder, it will copy on newly added data

HTML Code: 

With this option you can select the file to open

Please Login or Register  to view this content.

its stuck on

" With fn"

Try it this way

Please Login or Register  to view this content.

Thanks maniacb