Auto populate summary worksheet in text from multiple worksheets

Hi everyone,

I have a spreadsheet tracking visiting professionals. On it I have a summary worksheet at the beginning and then the other worksheets are data for each professional (i.e. name, email, phone, etc.). Because there will be hundreds of worksheets, I want the summary sheet to automatically populate with the data from the detailed worksheets. I have read a lot of forums similar to this, but using numbers that need to be summed on one sheet from multiple sheets. I don't need any kind of formula, I just need a straight copy. I'm pretty sure that this will require writing VBA code and can't be done by recording a macro. This is new territory for me. Please help!

Thanks!
L

Thanks for replying. I'm sorry for the delay getting back to you. I've attached to mock-ups of the files. The before file shows a summary page and three detail pages. The names of the learners have been hyperlinked on the summary page to go directly to their page. On the After file, I have added two additional worksheets and have put in formulas to automatically populate the Summary sheet as information is entered into these worksheets. What I need is to create multiple blank template worksheets with them automatically linked to populate the Summary worksheet on a larger scale so that I don't have to physically enter the formulas each time.

I'd like to know how to do it in general because I have other sheets where I will need to recreate similar circumstances.

Thanks so much for your help!

L

I copy the template and paste it into a new worksheet each time. I know there's a way to make a bunch of copies of the template at the same time, but I can't find the instructions where I did it before. The other part, where it autopopulates the Summary worksheet, I don't know how to program at all. Most of the fields will be filled, with the exception of Secondary Coach which may be blank sometimes. I still want it formulated to populate.

I just did this one as a mock-up. In the real one, the last name, first initial is used. Yeah a button would be great. It's a fairly new document so I anticipate the template changing a little bit. The main data being transferred to the summary sheet should be static.

Sure, that would be fine. Would the sheets be ordered based on their name (i.e. alphabetically)? If so, it might be good to put last name first. I could always use two columns for the name (first and last).

OK, so they would just be ordered based on when they were added (unless moved manually)?

That's awesome. It worked perfectly. Do I need to just manually name each worksheet or did you do something there since you said it had to be the name in cell A1? If I change the template, will it change all future added templates? I'm very curious how you did it.

That’s incredibly helpful. I really can’t thank you enough.