Hi!
I would like to know how can it be done to pull data from different tabs to create a main list. I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to create a main list. As well as to reflect any information they add or remove. I thought of using the formula =(tabName)!(cellNum) and it does what its needed. The problem is that they are so many tabs and I have to set a number of rows. If I set it to list 10 and if the tab they add 20 then the main list will not reflect it. I also have to name every single tab name on the "formula". Does anybody know a different way for this to be done?
Attached is the example. First tab is the main list(end result). Second tab, ABC its a tab example where the user will be entering the data. Third tab, DFG its another tab for entry data.
mailList.jpg
tab2.jpg
tab3.jpg
Bookmarks