I would like to have a column of the variables

0243
0244
0245
0246

so I can get the total of each of these data files in the next column.

Could someone suggest an approach?

Try the sumif worksheet function.

Cliff Edwards