I am using muliple worksheets / workbooks to manage vacation schedules for
the summer with vacation days colour coded. I have linked the cells from one
sheet / book to another but the colour (formating) doesn't transfer as a
value would.

Any ideas?