I have four active worksheets (one for each Quarter) and one Annual worksheet
which displays all the information of the Quarterly sheets.

The annual worksheet cells equal the same cell on the quarterly sheet. It
replicates the value but I need it to also replicate the fill colour of the
cell (as the shading is used to reflect the stage at which the booking is
at).

As the quarter worksheets are active, the values and fill colours regularly
change and it needs to be reflected in the annual. This also means a copy and
paste special is not possible.

If anyone knows how to equal the value and formatting of a cell, please let
me know! Help!