p45cal,

Many thanks for the solution. It works a treat.

Is it possible to include an error handler so that if a workbook does not exist for a BU, that it populates a "0" value instead of the trying to link to an external workbook.

As you are aware, if the workbook does not exist then an open dialog box is initiated.

The structure of each sheet will remain the same (across columns and rows).