Hello and welcome to the forum.

Why not just use a formula in sheets 1 to 3, something like

="Annual Report "&Sheet4!A20

That does not even require VBA.

cheers,