Open file dynamically and copy data using advanced filter

Hi,

I am newbie to excel vba and need your vba help.

My question:

Let's say I have an Output file open and I am on a particular sheet (active sheet) and when I run the macro it should give an option to open a particular file (get open filename) and after selecting the file it should filter the data from the selected file (in this case it is raw file and then use advance filter and copy and paste from raw file to output file which is open)

Note:
There is only one sheet in Raw file from where macro should pull the data and paste it into Output file (active sheet)

Please help.

Thanks!