Think you want to add a worksheet with a name "Report"
This code will do it.
Sheets.Add.Name = "Report"
However you can do this even with objects
See following code
Dim WS as Worksheet
Set WS = Sheets.Add
You can refer this new sheet by WS wherever at the code. You don't need to know anything about like it's name, location etc. Even you can give it a name later.
For an example think you want to name it as "Calculation". So below code will do it.
WS.Name = "Calculation"