How to Automatically Update an Excel Summary from Multiple Equipment Sheets
Question details
The user needs an automatically updating repair summary when data is entered on equipment worksheets such as 245D or 325BL, without manually changing formulas for every new repair.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user maintains separate equipment worksheets for machines like 245D and 325BL and needs a summary sheet that stays current as repair records are added.
- Observed behavior
- Formulas or summary cells must be manually updated whenever a new repair is added to an equipment sheet.
Before consolidating, check that every equipment sheet uses the same column order and headers, such as Equipment ID, Repair Date, Description, Mechanic, and Cost. Remove title rows or merged cells above the data so each sheet starts with the same header row.
Consolidate Equipment Repairs into One Excel Table and Summarize with FILTER
Best when you can simplify the data layout; one repair log table removes the need for per-sheet formula updates and makes the summary refresh automatically.
Separate worksheets for each machine make consolidation difficult because every new sheet or repair can require formula changes. A single repair table lets you filter, sort, and summarize all equipment records with a few static formulas.
Open a new worksheet named RepairLog and enter the headers Equipment ID, Repair Date, Description, Mechanic, Parts, Cost, and Notes.
Select the header row and any existing data, go to Insert > Table, check My table has headers, and name the table RepairLog in Table Design.
On the Summary sheet, enter =FILTER(RepairLog,RepairLog[Equipment ID]="245D","No repairs found") to return all repairs for equipment 245D.
Type each new repair as the next row in RepairLog. The table range and FILTER formula include new rows automatically, so the summary updates without manual formula edits.

Append Separate Equipment Sheets with Power Query for a Refreshable Summary
Use this method when the existing layout of one worksheet per machine must remain and you want Power Query to combine and refresh the data.
Use a PivotTable to Summarize Repair Records Without Formulas
Use this when you want a quick interactive summary by equipment or repair date without writing or maintaining formulas.
Use WPS Office as a Free Spreadsheet Alternative for Equipment Repair Summaries
WPS Office is a free, lightweight Microsoft Office alternative that opens and saves .xlsx workbooks, keeps familiar spreadsheet tools, and makes it easy to manage equipment repair logs with tables, filters, and formulas. Use WPS Spreadsheets as a practical alternative when Power Query is not available.
- 1. Download and install WPS Office: Go to the official WPS Office download page, download WPS Office Free, and install it on your Windows, macOS, or mobile device.
- 2. Open the existing equipment workbook: Launch WPS Spreadsheets and open the .xlsx repair workbook. The file opens in a familiar ribbon interface without converting the data.
- 3. Build a table- or PivotTable-based summary: Use Insert > Table to create the repair log, or use Insert > PivotTable to summarize Equipment ID, repair date, and cost without Power Query.

Frequently Asked Questions
Can Excel automatically update a formula when a new repair is entered on an equipment sheet?
Excel does not need to change the formula itself. Use an Excel Table or Power Query so formulas and queries reference an expanding data range. For example, an =FILTER(RepairLog,RepairLog[Equipment ID]="245D") formula includes new rows automatically.
What is the cleanest structure for tracking repairs across machines like 245D and 325BL?
Put all repairs in one table with an Equipment ID column. Then use FILTER, sorting, or a PivotTable to create summaries by machine, date, or repair type without maintaining separate-sheet formulas.
How do I append separate equipment sheets into one refreshable summary in Excel?
Convert each sheet to an Excel Table, load one into Power Query, use Home > Append Queries > Three or more tables to add the other sheets, then use Close & Load To. Refresh the query after new repairs.
Does WPS Office include Power Query for consolidating worksheets?
WPS Office does not include the Microsoft Power Query add-in. You can still open Excel workbooks, use tables and formulas, or use the free WPS alternative for general spreadsheet work.
Why does my summary not include new rows even after I type more repairs?
Check that the new rows are inside the Excel Table or query source range. If the range is a fixed reference like A2:C100, extend it or convert the data to a table so new rows are included automatically.




