I get it know. I don't need the macro  to combine lists  from different
files. I'll do that myself. I just need it to combine the lists on each
file (with the groups). I need to combine them without the blank rows
and also the problem that I mentioned earlier, that some lists (groups)
may have different number of people every week.

Each worksheet  contains like 3 sublists. Those are the ones I need the
macro to combine. In the first example I didn't include all the columns
that appear on my table, sorry. They always contain more than the
columns I need. The columns are not all next to each other, that is
what I wanted to illustrate on the second example.