It makes sense apart from the fact there is not a dropdown box in A5, from your attachment you have 2 sheets, tables and variences, all information looks to be inputted manually with no code to link it? tables lists different departments, and the varience sheet shows data monthly by various means, are you asking for, 1) the user chooses his/her department and can view the data relevant to that department and cannot view another department because that will be protected,2) is all the data for all departments entered on one sheet or will there be a different sheet for each departments data?

I will help you sort it if the above is what you want, but please give as much information as possible of what you would like to achieve

scouse13