my main problem is the part where it automatically counts which column to take for the next file/person:

Think about it, how would you as a person do the counting?

Now write down the description and post it here.