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).

Thanks Keeb for responding.

Leave the data as it is for referring. what I need here is the textbox value should be looked into both sheets and copy the rows into a statement.

But there is condition while copying the data from second sheet i.e. Resubmission Adjustment (Point 2).

Hai Keeb,

I think I haven't explained properly this is totally different output.

What I need here is look for textbox values in both worksheets and copy data into statements from both worksheets but in below conditions.

1. From Worksheet data copy the entire row where the text value match.
2. From Worksheet “Resubmission Adjustment” look for the textbox value and copy only those row where the 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.

I hope you got me explanation properly.

I am sorry for that.

Here is the explanation.

Let say the textbox value is = Al Dar Hospital (Quba) - 2015 the all the rows which is having this values will be extracted from worksheet (Data) to the worksheet (Statement) (See the attachment in my first post). Then see those batch no. in worksheet (Resubmission Adjustment) in column B and same worksheet column D if the values are Resubmission Adjustment copy only those row from worksheet (Resubmission Adjustment) to worksheet (statement).

I hope this time I have explained correctly to make you understand. kindly see my first post with the attachment showing what is the output result in worksheet (Statement).

then look for the sale value in

This is the result I want but sometime it is hard to explain in words what is in your mind.

Thank Keeb I will apply on my original data and get back to you.

thanks once again.

Hai keeb. it works on my original data thanks for all your efforts which you have done for helping me.

I have another question related to same file but not related to the topic. if you help me I will post my question.

if not I will marked this topic as solved and reputation will be added to your account.

Thanks for the advice I think it is better to marked this topic as solved. I will PM you the new topic link.

Thanks for your help once again.