Not possible and much of what you describe about your tabs does not seem possible either--though that may be missing details not found in your post.
An entire layout is based on exactly one TO. The only case where you can base another layout object on a different TO is in a portal--and that's the one layout object that you don't mention here.
I have no idea what you mean by "accordion" here.
That's not to say that you can't get the results that you want, just not by the methods that you describe.
Scripts, relationships, portals, portal filters, Popovers and ExecuteSQL can all query the database without specifically performing a find on the current layout or by performing any "find" at all. So there are options available to you.