Importing an excel sheet to another excel workbook

Thanks very much this works perfect. It copy the sheet over as is.

If i wanted the macro to run in a specific sheet already create called "Forecast" how could i do this?