This guide discusses combining tables from the same workbook only, not external sources or multiple workbooks. Make sure all the datasets you want to append are formatted as Excel ...

How to Make an Excel Spreadsheet "Read Only" for Other People. When multiple employees have access to company spreadsheets, it's important to prevent unauthorized changes.