Does anyone know how to make individual sheets into a workbook?

Start a new Numbers document.

In the individual existing documents (similar to a "workbook" in Excel) go to each "sheet (tab, similar to a worksheet in Excel) and choose Copy Sheet from the dropdown at the top by the tab.

Then switch to the new document. Go to the tab for any sheet there and chose 'Paste Sheet from the dropdown.

Repeat until you've got all the sheets in the new document.

Copy-pasting a sheet in this way automatically includes all the objects on the sheet and does not affect the formatting. References in formulas to different tables on the sheet will remain intact.

Note that in Numbers, unlike in Excel, you can easily have multiple tables on each sheet.

SG

Numbers doesn't do "Workbooks" or "Worksheets"

"Spreadsheet Documents" and "Sheets" are similar in some ways, but do not support the same feature sets as the "Workbooks" and "Worksheets" used in MS Excel.

Combining several Numbers Sheets into a single Numbers Document is a relatively simple process, but a tedious one with a large number of Sheets or several tables that you want to work with each other (as opposed to 'independently.'

Open a new Numbers document.

Add as many Sheets to it as you will need for the combined doc.

Put a place holder (eg. a text box with some text) on each sheet (assuming you are going to remove the default table that comes with each new sheet).

Save the new document, giving it a name, but don't close it. Saving it puts automatic resaves when changes are made to the document.

Copy the tables and other objects on one of the sheets that is being migrated to the new doc, then paste those items onto one of the sheets in the new document. Repeat as needed to move the other sheets' contents to Sheets in the new document.

When all have been transferred (actually 'copied') to the new document, do another save, then return to the new doc to clean up any format or layout issues to resolve.

Regards,

Barry

Are you asking about exporting a Numbers document to a MS Excel document?