Open the Excel workbook

1. Highlight Cell A1
2. Press Ctrl+Shift+End to highlight all the data

3. Click Insert
4. Select Pivot Table

5. Click OK to accept the default settings

6. Select the following Pivot Table Fields:

7. In Rows click on vPosition
8. Select Move Up

Results should show a total for all wages plus a sub total for ‘Position’ wages, plus a subtotal for all 'non position' wages

9. Repeat for each workbook
10. Rename Worksheet names for clarity if desired