Share/View/Edit with Collaborator on Pro Plan

I see these similar questions throughout the forum but I am still having a hard time figuring this out if someone could help, please. Our Company workspace is Pro Plan.

I have a workspace with several tables. Not all tables need to be viewed by others. For instance, the accounting tab needs to stay hidden, but P/L needs to be viewable. (these are on this same table, just a different view) If I share read-only file will it be seen on the current workspace? Or will it be a different base?

Thank you.