Weel I guess your explanation is not clear to me:
You have Quba as first textbox value.
The you can select either one of the values in the first Listbox
The second Listbox shows a list of items
and the Last textbox shows the vlaue 'Al Dar Hospital (Quba) - 2015' if I select 2015

Based upon that value you already filtered ALL the rows but you were asking for a filter on batch number AND where the value in column D of Resubmission Adjustement worksheet is Resubmission Adjustement

Well according to the macro result that is what it does.

If this is not what you require I suggest you mark the rows of data you expect to get as a result.

You are the one that understands your data best