I have 3 workbooks that we enter data for the business. Two are detail and one is a summary. Each worksheet in each workbook is a month. After 5 years I have 60 worksheets in each workbook.
I have two questions
1.) I'd like to combine all into one and have the detail sheets automatically update the summary sheet. If I do this, over time, I could end up with hundreds of tabs each representing a month. Is this a good idea?? (yes, I could auto update the summary workbook even if it was not combined)
2.) If I combine all workbooks into a single workbook, is it possible to have the 'current' worksheets always be the first three sheets in the stack?(for lack of a better description) I'd like to do this so that the lady who enters the data each day does not have to go to 'the right' each day when entering.
thanks in advance
Bookmarks