filter data and than load it into master file

[coolin]

Hello people,

I have a master xls file that needs to be updated monthly with data from source file.

I want to create a button on the master file with a macro attached that will check the headers from the source file to have the same value and order like the headers in the master file, in case of differences a msg box will say that there are differences between the 2 headers, and the macro will stop. I have to do this checking part because the header of the source file can be changed (order of the columns or titles.)
In case there are no differences between the 2 files, I want the source file to do a filter on column1 "Deal Description" for values that contain "word1", copy and paste data in the master file on the next available blank row, than do another filter on column 2 "Pre-Sales ID" for values that contain "word2", copy and paste data in the master file on the next available blank row.

Note that the source file must be open before the macro will start, in case it's close a msg box should appear with a message to open the source file.

If anyone have done something similar I will appreciate the help.

Thanks!