I have a "master" spreadsheet where I want to display a list of names
from different workbooks and sheets. I would also like this to be
automated--every time I created a new file with names in a certain
folder, for example, I would want that master sheet to be updated.

I'm not terribly familiar with Excel, but I'm currently working with a
non-profit where are human resources are low.