Is it possible to copy a worksheet into a separate worksheet so that the copy makes all the changes I make on the original copy? I have a worksheet with several hotels listed - reserved rooms/ daily count / rooms remaining / percentages taken and remaining. Each one is different. I need to send each chart to the appropriate hotel, but I don't want to send the entire worksheet. I would like to create separate worksheets for each hotel from the main page. Is there any way to do that so that as calculations change on the main page, they will also change on the copied page? Thanks!