Collect Tab information to create a main list

CR9596

New Member
Joined
Aug 3, 2018
Messages
2
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 compose 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 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. Does anybody know a different way for this to be done?

Below is the example. First table is the main list(end result). Second table, Alphabet Studies its a tab example where the user will be entering the data. Third table, Drawing table its another tab for entry data.
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}


Studies typeGroupIDCity1City2City3City4City5City6City7City8City9City10RegionMember's NameMember SinceCompanyTitleAddressCityStateZipEmailPhoneGroup President Name:Group President City Loc.:Group President Phone Num.:Group President Email:Group Tresuare Name:Group Tresuare City Loc.:Group Tresuare Phone Num.:Group Tresuare Email:Secretary Name:Secretary City Loc.:Secretary Phone Num.:Secretary Email:
Alphabet StudiesABC.DEx0x00x0000SouthBatman Guy28642xyzBusiness Relationship123 ABC StreetHollywoodCA77788bat@xyz.com888-123-4545John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000South westRobin Hood32070123CEO345 Stree CSeatleWA55236rb@123.com888-123-4546John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000NorthSamuel Clements1797BluebirdMarketing specialist987 L. house StreetHelenamt58964sc@bluebird.com888-123-4547John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Alphabet StudiesABC.DEx0x00x0000CentralLaura Ingalls40490FordData entry23B Detroit Lanejefferson cityMO56894li@ford.com888-123-4548John DoeHawaii123-444-5555jd@att.comJack Brownsydney111-222-8888jb@abc.comMiss Acanada888-999-888ma@net.com
Drawing StudiesDFG.ZY00x00xx0xxSouthJackson River65167Yellow stoneBusines ManagerArizona StreetHollywoodCA77788jart@yellow.com888-123-4549Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouth westSusan Salter31956Civil WarSales RepresentativeL StreetSeatleWA55236ss@cwar.com888-123-4550Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthMary Hays1797Hilton Inc.Business Relationship95 beach house Streetsan franciscoCa58964mh@hilton.com888-123-4551Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxCentralAlan shepard40490Hershey'sTeacher85 Rio AvenuecordobaAL56894li@hersheys.com888-123-4552Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouthRobert Frost28642ZooAnimal Control930 Pluto LaneHartfordCt77788bat@zoo.com0Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthJohn Hancock32070Football hallCoach867 Alaska St.OrlandoFL55236rb@football.com888-123-4554Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorthLewis Clark1797Cardinal techField tech.494 Golden GateHelenamt58964sc@cartech.com888-123-4555Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxWestJames Cook40490cherokeeSales Representative23B Detroit Lanejefferson cityMO56894li@cherokeecom888-444-5555Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouthEli Whitney28642National parksDirector of plants123 ABC StreetHollywoodCA77788bat@nationalparks.com0Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxNorth eastWalt Disneyh32070health technologiesNurse Tech.345 Stree CSeatleWA55236rb@flower.com211-555-8854Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxEastNoah Webster1797Flower deliveryGardener987 L. house StreetAtlanta GA589640211-555-8855Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxEastCody Bill40490Bird AcademySales Representative23B Detroit LanemaconGA568940211-555-8856Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxCentraljames marshall28642TelegraphNetworking administrator123 ABC StreetCharlotteNC25368sc@telegraph.com333-999-889Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com
Drawing StudiesDFG.ZY00x00xx0xxSouth westWilliam Seward32070innovations technologiesWeb specialist345 Stree CTampaFL78989li@InnoTech.com333-999-890Jefferson WilliamsSpringfield888-444-5555jw@text.comKen FrankfortIdianapolis211-555-8888kf@indiana.comMiss BDayton333-999-888mb@jackson.com

<thead>
</thead><tbody>
</tbody>





Alphabet Studies City1City2City3City4City5City6City7City8City9City10
GroupIDABC.DECityx x x
Name:City Loc.:Phone Num.:Email:
Group PresidentJohn DoeHawaii123-444-5555jd@att.com
Group TresuareJack Brownsydney111-222-8888jb@abc.com
SecretaryMiss Acanada888-999-888ma@net.com
RegionMember's NameMember Since dd/mm/yyyyCompanyTitleAddress CityStateZipEmail Phone
SouthBatman Guy6/1/1978xyzBusiness Relationship123 ABC Street HollywoodCA77788bat@xyz.com 888-123-4545
South westRobin Hood10/20/1987123CEO345 Stree C SeatleWA55236rb@123.com 888-123-4546
NorthSamuel ClementsDec-04BluebirdMarketing specialist987 L. house Street Helenamt58964sc@bluebird.com 888-123-4547
CentralLaura Ingalls11/8/2010FordData entry23B Detroit Lane jefferson cityMO56894li@ford.com 888-123-4548

<thead>
</thead><tbody>
</tbody>



<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>


























Drawing Studies City1City2City3City4City5City6City7City8City9City10
GroupIDDFG.ZYCity x xx xx
Name:City Loc.:Phone Num.:Email:
Group PresidentJefferson WilliamsSpringfield888-444-5555jw@text.com
Group TresuareKen FrankfortIdianapolis211-555-8888kf@indiana.com
SecretaryMiss BDayton333-999-888mb@jackson.com
RegionMember's NameMember SinceCompanyTitleAddress CityStateZipEmail Phone
SouthJackson River6/1/2078Yellow stoneBusines ManagerArizona Street HollywoodCA77788jart@yellow.com 888-123-4549
South westSusan Salter6/28/1987Civil WarSales RepresentativeL Street SeatleWA55236ss@cwar.com 888-123-4550
NorthMary HaysDec-04Hilton Inc.Business Relationship95 beach house Street san franciscoCa58964mh@hilton.com 888-123-4551
CentralAlan shepard11/8/2010Hershey'sTeacher85 Rio Avenue cordobaAL56894li@hersheys.com 888-123-4552
SouthRobert Frost6/1/1978ZooAnimal Control930 Pluto Lane HartfordCt77788bat@zoo.com
NorthJohn Hancock10/20/1987Football hallCoach867 Alaska St. OrlandoFL55236rb@football.com 888-123-4554
NorthLewis ClarkDec-04Cardinal techField tech.494 Golden Gate Helenamt58964sc@cartech.com 888-123-4555
WestJames Cook11/8/2010cherokeeSales Representative23B Detroit Lane jefferson cityMO56894li@cherokeecom 888-444-5555
SouthEli Whitney6/1/1978National parksDirector of plants123 ABC Street HollywoodCA77788bat@nationalparks.com
North eastWalt Disneyh10/20/1987health technologiesNurse Tech.345 Stree C SeatleWA55236rb@flower.com 211-555-8854
EastNoah WebsterDec-04Flower deliveryGardener987 L. house Street Atlanta GA58964 211-555-8855
EastCody Bill11/8/2010Bird AcademySales Representative23B Detroit Lane maconGA56894 211-555-8856
Centraljames marshall6/1/1978TelegraphNetworking administrator123 ABC Street CharlotteNC25368sc@telegraph.com 333-999-889
South westWilliam Seward10/20/1987innovations technologiesWeb specialist345 Stree C TampaFL78989li@InnoTech.com 333-999-890
333-999-891

<thead>
</thead><tbody>
</tbody>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Cross posted https://www.excelforum.com/for-othe...bs-in-excel-to-create-a-list.html#post4952716

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top