I have 10 columns in 10 Google sheets and in all sheets are the data labeled like
Month | Total number of winter/summer schools attended | Sr. No. | Title | Date | Venue | Organisation | Number of Female Participants | Total number Participants
Now I want to merge all columns in another sheet. Any formula or any option to marge all the sheet data in one sheet when they write and the new sheet fill automatically in Google Sheets.
Any help is appreciated.