Hi @0xGoose and Welcome to the Community 
!
I’m not entirely sure this is the kind of setup you actually have (
) … But, is this what you were trying to do ? (look at the buttons on the canvas 
)
The formula I used in the canvas button Stage 1 (for example) is :
[People & Stages].Filter(Stages = [Stage 1]).ForEach(
OpenWindow(People.URL)
)
And what it does is :
[People & Stages].Filter(Stages = [Stage 1])
It takes the table named [People & Stages] and look for rows where Stages = [Stage 1].
This returns a list of rows from my [People & Stages] table and more specifically, a list of people (coming from a People table where I’ve stored their “name” and some URL coming from my opened tabs 
).
[ ... ].ForEach( OpenWindow(People.URL) )
And now that we have the appropriate list of rows, this kind of says: ForEach() row in the list of rows returned by the Filter() (each individual row being represented as CurrentValue in the list, so People here is in fact CurrentValue.People ), open the url tied to that specific person
Another possibility, following a similar principle would be to have canvas buttons pushing the appropriate and individual OpenWindow() button you might already have in your table , using something like :
[People & Stages].Filter(Stages = [Stage 1]).ForEach(
Button
)
(Button being in fact CurrentValue.Button)
See the sample just below
Without a sanitised/anonymised sample of your current setup (or even just a screenshot), it’s a bit hard to be more precise …
But I still hope this will help you a little !
Don’t hesitate if you have questions