Merge multiple sheets data into one worksheet based on multiple criteria

If you set the auto filter to your requirements then you get the same result.

I filtered Data on Quba 2015
I filetered Resubmission on that worksheet as well as Quba
I the filtered the Batch No. and Resubmisson.

Result: three records!