Excel data Extraction issue

Hello,

I have the following issue with data extraction with Excel.
I have a list of data (barcodes) dynamically populated - which means that every scan is creating a new row of data in a specific column.
This might be thousands of scans.

I want to be able to take this list - practically copy and paste every scan to another excel file. From there i can short the scans according to my requirements.
The most important thing is that if i manually delete this list - lets say every month- and start the scans from the top again, i dont want to loose my data on the other excel file created.

These scans are entered in a worksheet which is open continously. The file in which the data will be extracted has to be open all the time also?

i have tried a lot of things for many days now and i seem to be stacked.
The problem with advance filter and function is that they are not dynamic, in terms that every time a new value is enetered in my list it is not transfered to the other file.

Any good ideas.???





By the way if this is possible to be done through excel functions instead of VBA - i would preffer that because i am not fa,miliar with vba and how to handle it.