Extract specific rows based on cell

Hi there,


I have a master plan workbook (master plan test) that retrieves it records from an external worked (MXM)
I have a VBA code but i would like to add more function to it


So far what the VBA code in the master plan test workbook does:
1.Start at row 6
2.Extract monthly records (For this example i used november 2017) based on the fabric delivery column from the MaximMainTable worksheet and place them into sheet 2
3.Extract specific columns from the worksheet and place them in the order of the master plan workbook heading
4.Filter out records with "OFM" and "Collar and Cuff". This two are entered manally by the users hence i do not want to the code to clear this records
5. an if else statement to produce a fabrication column based the fabric type column
6. sort the records according to the PO number

what i would like to add to the code:
1. Extract records by month based on the POtype column from the Modifytable worksheet in the MXM workbook. Extract those that states "Addition"
2. There are cases that the records can be modified. For example the PO " 100008213". In the Maximmaintable the colour is "Grey" but the column colour has been modified to "Navy" and it saved under the Modifytable. IS there a way where vba can retrieve the modified version instead of the original one?


Workbooks:
1. Masterplan test (Retrieves records from MXM workbook by month)
2. MXM
- MaximMainTable worksheet ( extracts all records original according to month)
-Modify Table (extract only addition and replace original records to modified records)