Combining two or more tabs whilst retaining colour

Hi guys, I’m trying to combine many tabs into one, but every time I use the ={Sheet1A2... etc. formula it resets the colours of the cells. A lot of the data is colour coded so I’m looking to do this without copying and pasting! Any help would be so appreciated!