Hi Sunny,
How about copying the new sheet to one with the permanent sheetname.

You can probably record a macro using edit, move or copy sheet, copy sheet.

Sub Macro14()
On Error Resume Next
Sheets("permanent sheet").Delete
On Error GoTo 0
' ---Sheets("Summary").Copy befo=Sheets(1)
ActiveSheet.Copy befo=Sheets(1)
ActiveSheet.Name = "Permanent sheet"
ActiveWorkbook.Save
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
David,

Another question, how do i just copy the used range?

Regards
Sunny