Autopopulate table in Sheet 1 when entries are put into sheet 2, 3, 4, etc...

Hi all

I have a file where routinely I'll create a new sheet and put in entries into that sheet. The "Master Sheet" is a listing of all of the entries from each of the sheets, which right now I am manaully copy and pasting once the sheets are complete. I've attached a sample of the file. Here is the synopsis:

--------------------------------------------

Master Sheet
The blue cells would contain a formula that autopopulates these cells when info is put in the appropriate sheets.
Approximately 20 columns worth of data would need to autofill. I merely listed 6.

Sheet - Template
This is the sheet I copy and would Rename as Sheet - C (when needed) and fill with new data.


Sheet - A
Twelve lines were filled in, and autopopulated in the master sheet once a YES was placed in "column L"
The grey cells is what MAY be filled in.

--------------------------------------------

If anything else needs clarrification, please let me know! I'd really appreciate any help. I'm not really getting anywhere on my own.

Thanks!

Thanks for the reply.
Yes, all of the data on the existing and new sheets are in the same format/sequence.
If I am understanding you correctly, I don't think this will solve my issue.

I am not wanting to add across sheets. Each entry is unique and would be displayed seperately. I simply want all entries in Sheet-A, Sheet-B, and any additional sheets, to appear in the Master Sheet once they are complete (a YES in column I).
There order is not that important, simply that when Yes in put in 'Sheet - A'!$I$10, cells 'Sheet - A'!B10:G10 automatically appear in the master sheet as a completed entry. I'm currently attempting a combination of "Index" and "Vlookup" function, but having difficulty only showing completed entries, not blank lines.

Thanks for your reply though. Hopefully my request is a bit more clear.

Thanks for the suggestion Max. One aspect your solution is missing is the ability for all the rates to appear there at the same time automatically when adding a new entry into ANY sheet, so manually replacing the sheet names would not be ideal.

I've attached a file with the solution I came up with. In the "Master" Sheet I used a countif function to determine the number of quotes for each sheet. If a new entry is added into Sheet-01, then the number of quotes in column G will change, and the number of entries displayed in the "Master" table will change. In column J, once the number has reached the # of quotes (ex. J21), the formula knows to start on the next line with the new Sheet #.

I've included a lot of helper columns to make it easy to change if necessary.

This master sheet is to make it easy for me to see what entries are actually complete, and then daily (or weekly) copy and paste the master sheet and paste it in another file with all entries. The ONLY feature I am missing right now is an ability to make the Master table no longer show entries i have already copy & pasted into the other file. Including a helper column in the master sheet is what i think i need, but how exactly it would work is beyond me. if anyone has any suggestions on this, please let me know.

Thanks!

> .. One aspect your solution is missing is the ability for all the rates to appear there at the same time automatically when adding a new entry into ANY sheet, so manually replacing the sheet names would not be ideal.

Ah, but that's not correct to say. You probably mis-understood the implementation steps outlined in my earlier post. You could always copy/propagate the extract formulas for each child sheet in sections below in Master (I gave you the formula/steps to do for Sheet A). That was what I meant. The extract formulas are all similar, you just need to change it to point to the other child sheetnames, then copy across/fill down as required for each child sheet. If you do this, then your Master will immediately reflect all the lines from any child sheet with "Yes" indicated in col I - its fully automated

I figured that was the case. As I try and wrap my head around your method, I'm beginning to think it may be a better solution, but what I have is working, so... I'll stick with the devil I know. Thanks!