hey c991257 - Thank you for the reply. Yes, that is exactly what I need to do. Because it's going back 30 days it will need to pull data from the previous sheet in the workbook. That is the part I am not familiar with. I know how to add data from multiple sheets. I am just not sure how to grab the data from ONLY certain cells to generate the 30 day total properly