I'm that guy II

[ToledoTom]

I posted this in the incorrect spot about 30 min ago. Because I'm using google sheets, I'm posting my question here. I'm very sorry about that subject ine. I'm a physical therapist that has recently taken an administrative role. I just don't know the spreadsheet "language" to even ask my questions or search for it on internet.

I need a few sheets to interact with each other. I need the "Name" in the range A3-A8 to auto populate in the "staffing" sheet, from A2-A7. I can do that. But, here's where I'm stuck. I need the range on the staffing sheet B2-F2, to stay attached to the Name in A2 on the "staffing sheet".

Here's where it gets even more difficult for me. On the schedule sheet, the names will change spots almost daily. Then eventually those names will be replaced with other names. Yes, the information in the cell range B2-F2, on the staffing sheet changes as well.

 

[datatronics505]

Well hello that guy,
Welcome to the world of constructing spreadsheets and databases! I'll start by being Captain Obvious: no subtitle row in your table, like you did in the first pic. Teams are obviously separate items which calls for separate table/spreadsheet on its own. So you'll have a separate table for Team A, another one for Team B etc. Those would be your dimension tables: think rolodex.
Then you'll have your fact tables: tables that list facts that happened. Who bought what and for how much, who worked when and for how long... Perhaps in your case you don't have to because you are dealing with just a handful of people, but assigning a numerical ID to each item of the previously mentioned dimension tables is highly recommended when constructing databases. So that you'll know which of the 10 John Smiths in your org worked the Tuesday evening shift 6 weeks ago.
Sift that through and then do just a cursory search for how to reference fields from different sheets by absolute position. It is really not that difficult.