Seperate Data Streams From one Collection

Hi, Im new here

im having issues with my data i have a page with collection template lets use real estate for example so i added 3 portfolios when i click on any one of them i want the corresponding data in table form to show from a google sheet so i figured that out the problem is when i go to any other portfolios from the collection it shows data from the last edited table.
how do i have different tables for each entry in collections?

Can you show us some screenshots of how you are setting that up? What is the “action” when you click on each of the portfolios? Is it “showing details screen” for the current row?