Compiling Certain Data into Another Worksheet with VBA

[betotototo]

Hi all,

I have an infinite amount of invoices with data AFTER Sheet("toi") and an infinite amount of employee sheets BEFORE Sheet("toi") so hardcoding isn't going to be possible. I need certain numbers pulled and summed using a vba macro into Sheet("MASTER") that's already created.

My problem is I'm new to vba so when I'm looking at code, I don't understand what the heck is going on! I've seen some code that compile data from a column starting at a row and going infinitely down. However, I have a stopping point so I don't know how or where to tell the code to stop.

Here is a link to a sample googledocs I made: http://goo.gl/wLuXm

So I have MASTER, Brian James Mike Doug Chris Matt Nate (I'll call them emps), toi, AIR BAD CAR DAD ELF FAN GUM HAT(these are invoices, so I'll call them inv).

The inv are color coded yellow green and blue. If you look at the MASTER sheet, I've also colored them accordingly to show where the inv data should go. Since there can be an infinite amount of inv, I need a way to call all yellow blue and green sections in the inv and put them in the right spot in MASTER. And do this for each subsequent inv (all inv will be created after Sheet("toi")).


**Btw, the inv will be put in numerical then alphabetical order as is the list on the MASTER sheet. However, sometimes the list on MASTER will not have a corresponding inv (note FAN is on the MASTER list but does not have an inv tab). The vba code would have to find a way to respond to this.


I'm not sure what I'm getting into here but please let me know if this is possible and the difficulty level. I tried to follow http://www.vbaexpress.com/kb/getarticle.php?kb_id=151 but I don't understand it all.

Please help me if you can. Thanks in advance.

 

[betotototo]

I still haven't found much or learned much information on this. Can anyone help?