VBA - Auto populate cells based on another tab

[Lifeless]

Hey all,

Could you please help me,
I'm trying to Auto popular cells to make my life easier.

Basically, in B6 on the "Auto" tab, is the name of the screen, followed by the start time of that screen in F6
I'm wanting to put that into screen 6 on the tab named "FOH01" in H12

Then the next time screen 6 shows up on the "Auto" tab is in B18, therefore that needs to go into the 2nd performance which is K12 in the "FOH01" tab...

I'd be able to do something like that myself easily, however the "Auto" tab changes daily, therefore it can't be linked to the actual cell, it needs to be some sort of VBA coding

Please let me know if you need more information
Thanks for your help, it'll really be appreciated.

[AlphaFrog]

Put this formua in H12 to get the first instance of Screen 6.
It's an array formula. Confirm with Ctrl+Shift+Enter
=INDEX(Auto!$F$1:$F$100,SMALL(IF(Auto!$B$1:$B$100="Screen " & FOH01!A12,ROW(Auto!$B$1:$B$100),""),1))

In K12, use the same formula but change the red 1 to a 2 to get the 2nd instance. You could drag copy the formulas up to get the other screen times. The formulas will automatically update when you change the data on FOH01

[Lifeless]

Put this formua in H12 to get the first instance of Screen 6.
It's an array formula. Confirm with Ctrl+Shift+Enter
=INDEX(Auto!$F$1:$F$100,SMALL(IF(Auto!$B$1:$B$100="Screen " & FOH01!A12,ROW(Auto!$B$1:$B$100),""),1))

In K12, use the same formula but change the red 1 to a 2 to get the 2nd instance. You could drag copy the formulas up to get the other screen times. The formulas will automatically update when you change the data on FOH01

Brilliant, worked like a charm, thanks for your help AlphaFrog!