VBA Need help with additional loop to copy range to different worksheet

I'm attempting to help a friend create a worksheet to consolidate his financial data. I've been able to muck my way through most of the VBA code by looking at examples on the forum.
However, I cannot figure out how to add the last loop or where to place it.
I can copy the values from the P&L sheet to the DATA sheet but I cannot discover a way to also pull the values from the BalSht sheet to the Data sheet.
I think the BalSht loop will be almost identical to the "P&L sheet loop, and be placed just below it - but I'm not successful in multiple attempts and days of trying.
How can I accomplish this? Please help!
Here's the VBA code:

Please Login or Register  to view this content.

Excel file attached.

WOW, Leith! That's AWESOME and so much cleaned than the code I developed!!!
On behalf of both myself and my friend, THANK YOU so much!