"...I have made the front sheet have all required data from the first subsheet..."
How have you achieved this?