When creating a new Google Sheet, by default, it will have one sheet tab at the bottom of the page. The program is designed so that you can have a maximum of 200 sheets.
To add additional sheets, you can click on the plus sign in the sheets toolbar.
One sheet will be added. To rename the sheet, click on the dropdown arrow next to the Sheet,