I would be extremely grateful for some help with this problem. Thanking you in advance.

I have a table with conditional formatting applied. This table uses data from elsewhere within the same sheet to colour code my cells.

How can I copy and paste this table to another workbook? Each time I try I lose the colours as they are dependent on the data in the other sheet. This data is continuosly updated so I want to make a record of this without having to manually colour each cell.