complete information was not given. are the monthly accounts in different sheets or different workbooks. Better to have them in sheets. what is the names of the sheets
January, February etc or Jan, Feb etc
you better have a drop down box in a special sheet or call it main sheet .