Merge multiple sheets data into one worksheet based on multiple criteria

I am looking for a help to combine 2 worksheet data for non-identical headers.

Click Search provider button on ribbon and enter search criteria (For example Quba) and click search. Below listbox1 will give the list of provider per year. When a user click any of the months (For example Al Dar Hospital (Quba) - 2015) the textbox grab that clicked text i.e. Al Dar Hospital (Quba) – 2015.

Now what I am requesting here is when I click Export Data button then VBA Macros will look for that text value on both the worksheets i.e. Data & Resubmission Adjustment and copy entire rows on below conditions.

1. From Worksheet data copy the entire row where the text value match.
2. From Worksheet “Resubmission Adjustment” look for the text value and look for batch no. In column B which is present in Worksheets “Data” in column G and Worksheet “Resubmission Adjustment” in column D cell value is Resubmission Adjustment copy only those rows.

After matching all the criteria and copy the rows and past it to the worksheet(“Statement”).

To understand the request better I am attaching the sample file (Demo).