I have a workbook which references cells in another workbook. The problem is, the sheet these cells are referenced to does not currently exist... yet

Workbook 1 opens with workbook_open macro which then opens another workbook and creates the new sheet in question. A bunch of other stuff happens in workbook 2 before switching back to workbook 1. Workbook 1 has reference links to the new sheet in workbook 2 but by the time that happens the links are broken and rendered useless.

Is there a way to stop workbook 1 referencing the missing sheet in workbook 2 before its been created?