Autofilter various conditions and copy the selected columns of visible range in diff wrkbk

Attached is a sample data.
I am looking for a macro which will apply filter on multiple columns and copy the selected columns from the visible range and paste it in a new workbook.
Example Conditions:
1. If 'Format' = text and 'Attribute' value begins with "$" and value is >" 45" in the tab "Application"
2. If 'Default' is not empty and 'Visible' ="TRUE" in the tab "Application"
3. If 'Log' = TRUE in Application tab for the given and Form ID and form Name and in App validation Position = "0" or If 'Log' = FALSE in Application tab for the given and Form ID and form Name and in App validation Position = ""
4. If a duplicate row exists in Validation Steps tab