Macro for copying specific data from excel files in a folder to a newly created excel file

Hello,

I wanted a macro which would open all excel files in a folder and copy paste specific data into a newly created excel file.

Data :
1) status = open, pending and in progress
2) Task name = RTDI and Apply verify price
3) Container number = "Blank" (It wont be written - Blank cell)

I want data's to be copied for the above scenarios. Thanks any help will be really appreciated :D

Thanks for the reply..But what i want is datas in excel files consilated into one new excel file...I want the option in the macro to add in the directory and the destination directory...

@Raju

So from you uploaded worksheet only line 3 will be pulled in and loaded to a new Excel File?

From row two....all the data should be copied onto a new vessel or to the next sheet i.e. sheet 2...

Now in column, data will be available till column Q and data can be unlimited.

Thanks for the reply