To merge multiple sheets you must 'Share' the workbook first. After having shared the workbook, when other users make additions or changes in a copy of the shared workbook you can consolidate these into a single workbook. To do so you will need copy all of the 'cloned' sheets into a folder (with different names than your 'master' sheet) and then choose the "Consolidate and Merge" feature.

You can then review and accept some or all of the changes that you have merged from the cloned sheets.

SAR