I have a number of separate ODS files all formatted exactly the same (columns and rows) that I want to merge into a single master spreadsheet.
Consolidate data by using multiple page fields. You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates Marketing and Sales apart from Manufacturing, and another page field that consolidates all three departments. Mar 21, 2021 Method 1: Combine multiple workbooks into one workbook with the Move or Copy function. If you want to merge all the existing files into a new Excel workbook, create the new Excel workbook and open it. But if you're going to combine all of them into a current workbook, open that workbook.
Similar question asked here
Is copy/paste an option, or is the number of files too large?
How are the 'multiple ... files' identified as a group? (A folder? Systematic names? ...)
How many files? How many sheets per file?
Shall the merging be done onece and for all?
Shall independent files remain, and the master link them in?
How shall the sheets from different source files be distinguished in the 'master file'?
Are they differently named from the beginning?
Do you want an automatic procedure?
You will need to consider a few things yourself.