How to summarize the five insurance details exported by the Social Security Bureau into a table?

First, add four worksheets to an Excel table, and put the details of pension, medical care (including maternity), unemployment and work-related injuries exported from the payment platform of the Social Security Bureau into these four tables respectively, as shown below:

In the case of a large number of employees, you can use the worksheet with the most complete personnel list as the main table, such as the industrial injury insurance table as the main table, and use the VLOOKUP function formula, as shown in the figure:

This method can summarize the payment details of pension, medical care and unemployment forms into work-related injury insurance forms, whether it is necessary to summarize personal code, payment base or payment amount.