To clarify, i would need to make a list of the changes that i need in the 'Database' tab of the sheet that is running the macro so it can pull the information for all files from there??

What if i wanted to add additional things (not changes as such, but new data) to the original list, would that be a separate list on the same tab (Database)??