I don't really know if this is possible or where to start (which is probably why I can't search for it very well)
I have a workbook with a number of identical worksheets (one for each month) - each worksheet has data that can be entered into about 30 columns via drop down. Each column then...