3 collections , 1 table, 1 dynamic page

Im having a hard time thinking about how this would work.

I have 3 collections of data - I know it is possible to link data displayed from all three collections into 1 table. A field on the table is linked and opens a dynamic page.

Is it also possible to have the fields on the dynamic page display information from all three collections using a field from the table to link the information?

Lets say my table on a regular page displays the following:

Field: name(collection1) Field: number (collection2) Field: Color (collection3) Field: Price(collection2) Field: Size (collection1 )

Field: name(collection1) opens a dynamic page where I want text fields to also display:

Field: number (collection2) Field: Color (collection3) Field: Price(collection2) + other fields from all 3 collections.

I imagine I would set both the table and the dynamic page using the same filters? I guess I am confused because the dynamic page displays many different fields using text linked to datacollection while the table manager helps me do this already…

anyone have thoughts on this? thanks!