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