Pivot Tables
 

I am new to this and I finally got my dropdown lists to be dependent upon
each other, so I am so happy that is over... Next thing is can I do Pivot
tables that update themselves? I am not familiar with that at all! I am
learning as I make this workbook.

Also is there a way to get Cells that have information about a specific
location (like a building) to self generate themselves in the worksheet
allotted for them? There are like five buildings that have their own
spreadsheet. Sorry this might be hard to read, I don't know really how to
work my questions. Thanks!!

Ali