I have a workbook with 4 tabs - 1 tab for each region. In each tab I have a table with hundreds of rows of data which increases each month. Each table has the same columns, same structure, but I keep them separate for ease of reporting, etc. However, I need to have a fifth tab to have a summary of all 4 tabs. I don't want to continue to copy and paste each month because it is a big hassle. Is there any way to create this summary tab so that it reads the other tables automatically and transfers over all the data each month? Please help. Thank you in advance.
Bookmarks