Let me be more precise

None of my Sheets are Hidden not any cells are hidden.

I have number of items in my dropdown list.
I have created formulas for every item from the dropdown list so that if any item if it is selected it matches with other sheets in the same workbook and gives results.

Currently I have to select each item individually, get the result and take a print out.

Can it be possible that all the items in the drop box are selected, automatically the results are changed for each item and print out are taken in one click only.

If I understand correctly, this would take some significant macro coding to accomplish. However, you would have to provide someone a copy of the spreadsheet and spend a little time with them showing them exactly what you need.

I'm sure some of the experts will be happy to assist you.

I'm really not following what you want. A sample sp[readhseet attached to your post may help.