I wasn't referring to data within a worksheet. How would the macro
know which lists  to combine? Which directories, which files, which
workbooks, which wooksheets?

I'm assuming a given worksheet  would only contain one list, and only
contain that list. Per your other answer, each list would contain AT
LEAST the columns of data you need, but could contain more?