Welcome, @MikeysMoney25 
Curious about this:
There is a way to do it but it takes a little setup.
I would recommend just using one Google Sheet and linking all the accounts for the 3 entities to the single sheet.
THEN just use a category/group structure to keep things organized.
Group for Personal, Business 1, Business 2
Since the categories need to be unique you’d then just prepend them with something unique like “Mikey - Dining Out” and “Biz 1 - Dining Out”
Then you’ll be able to see everything in one place.
I recommend the Monthly Analysis sheet for the spending trend lines you’re wanting to see and checking out some of the other community solutions for the other reports you’re wanting.
Hopefully that helps point you in the right direction.