Hey guys, looking for a little help here and I know just enough about Excel to think this is possible, but no clue how to build it.

I want to build a master budgetary workbook that will include all the Purchase orders for an upcoming film as seperate sheets. Each sheet will link all info to a master database sheet, which will allow us to keep a strong eye on our budget. Doesn't seem too difficult yet, but I will have over 150 POs and I'd like to figure out a way to automate the process so as soon as I start a new sheet, it is added into my master.

I know the long way of linking cells across sheets, but that seems very time consuming and I'm sure that.

I will also need to be able to sort and total things by budget code, sometimes with more than one budget code per PO.

I'm a quick learner, have the basic sheets created, just need a little help pushing in the right direction towards the functions that would work best.

My skill level right now peters out pretty soon past the autosum function.

Thanks!