Multiple worksheets- need some data to be applied to all worksheets from main worsksheet

Can you reattach the sheet with some manually entered examples? By Community type, do you mean a code or just "Location 1", "Location 2", "All" etc.?

Please help...Sorry my description of the problem wasnt to great. Here is what I am trying to do and I am not even sure if it is possible. I am creating a budget with several worksheets. I need the worksheets "to talk" to each other. I want to be able to input information on the Monhtly worsheet, and have it automatically fill out information to the location worksheets (there are 5 locations). For the most part one expense/ invoice that will be enterd on the monthly worksheet will be for all five locations,However, and this is where it gets tricky, sometimes an expense will only apply to one location not all five, I want to be able to enter an expense and based on community type have it automatically fill in on the indicated Locations worksheet. I have attached my sample worksheet that I am playing around with. This is my first time posting so if I did anything wrong I am sorry.here you go I put some generic information in hopefully this will clarify a little better, its titled budget 2