C&P data from 1 WB to another WB without actually seeing the opening of the pasted WB.

Hello friends, Hope all is well!

I have a folder called: MD; in it, there are two workbooks:

MDDB and NY.

Can you please help me? I am hoping to have a vba code, in the workbook MDDB module that will:

1. Go to sheet DB in MDDB, and filter column D, the filter will be made on the word NY (i.e. show the data related to NY only).
2. Then copy all the data in DB from A to R, without the headers.
3. and Paste the copied rows (without the headers) onto DB of the workbook NY after the last filled row (A to R).
4. without letting the workbook NY open. At least without letting it look visible please.

I tried doing all the above, and I did successed but in a long and untidy way.
If someone would kindly help me; I will surely learn from that experience, and
Will be able to do it on my own, and will pass on the knowledge for sure.

Thank you so much for the continuous phenomenal help in advance!