Window.Caption (Excel)

Returns or sets a Variant value that represents the name that appears in the title bar of the document window.

When you set the name, you can use that name as the index to the Windows collection (as demonstrated in the example.)

ActiveWindow.Caption =  "Consolidated Balance Sheet"