I have a spreadsheet with multiple sheets that reference the same row information (First 6 rows) in all three sheets. I can make the second and third sheet update for test auto matacally from sheet 1 when I use the =FirstSheet1! type of command. However (You knew there was a catch) I don't get the cell formatting or the color of the cell copied. Ideas??