find data not used, find last row and paste(stuck on last part! pls help)

Hi all, I am so grateful for everyone's help here on this board as it took me a far way!

I am working on building summary database which utalizes 2 different data spreadsheets and currently am stuck on last part. I am attaching what I have put together so far, and added detailed notes what I am trying to accomplish inside..

to give quick overview, I have 3 excel tabs:
-total_Summary (where I summarize profits anything for (this month+previous month) and anything that has (nothing for this month but has for previous months)
-this_month_profit
-prior_months_profits

"prior_months_profits" contains information for past 2 years.. every month we sweep monthly data to "prior_months_profits".. to track profits, I combine current month profits with any previous month profits.. any remaining items in prior month profits which has no current month profits I still need to reflect..this is the part where I got stuck.. as I need to find the data, seperate it and then paste it in my summary tab on the last row after where I combined current month with any data that matches to previous month.

I know this might be little confusing, so I made it little more user friendly in the attached file.

Please if anyone could help with some feedback or suggestions it would be greatly appreciated.

Thanks so much

Dan