I hope some one will help me.
I have a worksheet with multiple tabs and keep adding every month with new tab.
I would like to get all the records from all sheets to the master tab and create summary on summary tab. All the sheets have same headers but around 90+ columns and many rows.
Also, I would like to create two buttons, 1-Reset and 2- Update on one tab if possible OR on 1st row of the master at A1 and B1
Update button= to have all records from all the present sheets to the master
Reset button = To clear all the update from master tab before clicking update again to avoid duplicate recording of all sheets which I encountered before
The sample file is attached.