This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.
Tip: If you frequently consolidate data, it might help to base your worksheets on a worksheet template that uses a consistent layout.
Use the value 3 if you do want to update the links.
Another change you can make is to merge from all files with a name that starts with a specific name.
There are two ways to consolidate data: by Category or by Position.