I have a workbook with 9 worksheets; one of the sheets is the master; created to be the other 9 sheets compiled into 1. I need to set it up so that any new data entered into the new separate sheets is automatically entered into the master sheet, in the first blank row.
It'd be great to add a "Run" button to refresh updates. Please also advise as to how to add more tabs if need be. I have no experience with VBA/macros.
Thanks in advance for any help.
Update Master / Summary Tab with all new entries in other sheets / tabs
Consider using your Master sheet as your input sheet. That way you only have to implement 1 code and you can add as many sheets as you want. Otherwise you will have to create a button and implement a code for each sub sheet.