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

[Melvinrobb]

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!