The Excel workbook and worksheets are just a file container for worksheets and related items .It's what you're going to save. it's what you're going to retrieve workbooks contain one or more worksheets the default is one a workbook can be as simple or as complex.
in theory you can have an unlimited number of worksheets
As you desire in theory you can have an unlimited number of worksheets in a workbook in practice. The number of the worksheet you can have is determined by the power of your computer the complex of your spreadsheets are informally known as tabs in line with the appearance of the worksheet name in excel.
Get Familiar with Excel Worksheet look at the worksheet tabs
We look at the worksheet tabs to the right and you can see a plus button. If we click on this plus button we will create a new worksheet can also be created by hovering the mouse over one of the tabs and right-clicking. We have the option to insert a worksheet equally using this right-click while hovering over the tabs we can delay delete rename or change the color.
For example :
If we wish to change the color of a tab we can do is that we can do that here now. It can be quite useful if you've got several tabs and you want to color-code them for different purposes. It can simplify navigation around the workbook multiple worksheets provide users with many options in terms of organizing and categorizing data calculation and outputs in excel.
To Get Familiar with Excel Worksheet formula that span multiple worksheets navigation
We can have a formula that span multiple worksheets navigation between a relatively small number of worksheets can be made very easily using the control page down or page up button.