I have an "item check in" file that has a macro to create a batch folder. It
then saves a copy of the file for each item based on how many items need to
be checked in. The name of the folder and number of files depends on the
number of items in the batch and company the batch is for. For example, for
three items for CompanyX it would create a folder called CompanyX.3 and then
save copies of the file as CompanyX.1, CompanyX.2, and CompanyX.3 in the
folder CompanyX.3.

I would like to find a way to add a given cell (A1) from each of the files
and place the sum of these cells at a different cell (B2) on the first file
of the batch (CompanyX.1).

Remember the number of items (files) can be anywhere from 1 to 50.

Thanks in advance