The only way: use a VBA macro. E.g.
ActiveSheet.PageSetup.LeftFooter = "Check: " & Sheets(SETTINGS_SHEET_NAME).Range("F4").Value
Pages
Other stuff
The only way: use a VBA macro. E.g.
ActiveSheet.PageSetup.LeftFooter = "Check: " & Sheets(SETTINGS_SHEET_NAME).Range("F4").Value