I have not been able to find a solution to this problem. I am running excel 2007. I have 2 sheets, one is a log sheet and the other is a summary sheet. When the log sheet is opened, a new log sheet is created and a summary sheet is created. The log sheet is renames to mm-dd-yyyy Log and the summary sheet is renames to mm-dd-yyyy Summary. I need to copy various fields from the log to the summary. I THINK I can transfer the dada ok, but the problem for now is getting the correct sheet names. Ex: I need to copy cell F@ from the log to the summery. Please help. Thank you.