A workbook is the whole Excel file; a worksheet is one tab (sheet) inside it.
Try it with AIA workbook is the file you save (.xlsx). Each workbook contains one or more worksheets — the tabbed grids at the bottom. Formulas can reference cells across worksheets within the same workbook.
Limited only by available memory — there's no fixed cap in modern Excel.