thanks for sharing! unfortunately, I'm unable to use add-ons at my workplace.

For the VBA option, is there any way to detect changes to values within each workbook's rows, so they can be updated in the Master file accordingly? The current one simply adds whatever is available within individual workbooks.

Another implication is that if individuals make changes to their own workbooks, I won't be able to tell unless I read through each entry manually. Is there any checking mechanism I can put in place then?