Sorry for incomplete information.

Concept is the same as before. If the period falls in both the sheets it should extract records from both sheets.

for example:

If the period is March 2014 to November 2014 then the rows copies from Data worksheets and if the same period the batches listed in Resubmission Adjustment worksheets then should copy that rows.

For example Al Dar Hospital (Quba) period of March to November 2014 their are 2 batches within the same period which is NB20150929-4945 & NB20141120-6039 also been added to statement worksheets. Means extract row from Resubmission Adjustment worksheets and past to statement worksheets.

So the main data source is from Data worksheets only.

I how this will clear your doubt.