Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)

It seems there is some kind of confusion in understanding.

Now the user extracting Al Mana General Hospital – Dammam for open batches for the period of January to June 2015 but after running the macro it is extracting rows from Resubmission Adjustment worksheets only. Not copying data from Worksheets(“Data”).

The script should look data in data sheets first then compare the batch number with Resubmission Adjustment worksheets batch numbers in column D before exacting data.

Copy of the sample output file is attached for your reference.