How do I auto-populate information from one tab to another in sheets?

CADDmanDH 

Had the same question as OP, but disappointed there were only follow questions versus and explanation of an actual answer.

You've never heard that sometimes you need to answer a question with a question (or two)?! As in sometimes, the situation needs a bit more definition. As in sometimes a quick "answer" is less helpful than a bit more back-and-forth first to make sure all parties are on the same page?

Not to be defensive, but I would point out your opening comment doesn't serve to endear me to you.

In may case, YES, Everything would be the same from one Tab to the Next as it's the same form; and YES, I would manually rename each tab as they are Invoice #'s per each form.

Edit: The new Data would drop into the Master List of Data from the Tabs, to which I already have a chart set up to incorporate that data for my needs.

Nevertheless, without any further ado, what I'm guessing (in the absence of further  definition of the situation) is that the INDIRECT function would work in the OP's case, and maybe even in yours; you'll have to find that out.

With INDIRECT, as I've used it in my own situation (which may or may not mirror yours), I've entered, in a single column of the master or summary sheet, the word/text that serves also as the label on a tab from which I want to extract date. Then, across the top of the master sheet, I've entered into a singe row the specific cell references in those various sheets from which I want to extract data.

What INDIRECT does is construct a complete reference to another spot in the workbook. In this case, it is to a specific cell (or series of them) in another sheet in the same workbook, which I believe is what you're trying to accomplish.

The INDIRECT formula looks like this:

=INDIRECT($D6&"!"&C$1)

• where $D6 is the cell containing the sheet's name (the absolute reference to column D keeps that constant as it's copied across other columns; the relative reference to row 6 allows it to change as it's copied down)
• The &"!" designates the foregoing as a reference to a sheet in the same workbook (I'm assuming you know the concatenation symbol &)
• The  final reference to C$1 is to the cell in which there is a cell address to the cell(s) in the various detail sheets containing the data elements you want in the summary sheet.

Let me know if that works. If not, come back with a description of what does happen, and maybe a sample of your actual workbook.

Kvojas 

You wrote: Do you know if there’s a way for excel to recognize a word and then put the thing next to it into a separate sheet?

And the answer, typical for Excel, is that there no doubt are multiple ways to do it. 

But also, typical for Excel, it makes a LOT of difference how you're entering that data in the first place, what the whole process is, what the desired outcome is.

If I were creating something along the lines you hint at--which I assume is a way to track grades for a class in school and have Katie's and Hayley's grades all summarized neatly, maybe averaged, etc.

One thing to keep in mind is that Excel is really good at taking what I'll call "clean data" in a consolidated database, and then extracting meaningful subsets of it.  I've attached a sample of what's possible. Note that on the DB sheet, each of those data elements is it's own column--that's what makes it "clean". 

Then on the Individual Record sheet, you can select a name and see a list of the assignments for which there's a grade. There's really no need to have a separate sheet for each person, just use this 'dashboard' screen to produce a summary of grades.  By the way, this solution does require the most current version of Excel in order for the functions FILTER and UNIQUE to work.