I have a lot of data that is spread out over several sheets, I would like to be able to make a workbook that autofills with the data from the sheets. My problem is that the data is generated daily and saved on a new sheet by date such as "061213.xls" would be today's sheet. Can I make a workbook that accounts for the already generated data and the data to be generated?
Bookmarks