VBA - Auto populate cells based on another tab

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.