Hello, very new to all this so might be getting a little too creative but I have a worksheet which has a summary for sales and then I have created other worksheets via month which automatically update the summary. What I would like to do is add another sheet as a Sales list where you can see every sale and what status it is on. We would like to use the sales sheet as the main data entry which will complete the monthly worksheets as well using the filter of date and status if possible. I know you may say to just have the one list but then it still won't update the summary as we require unless anyone has an idea to possibly make that work.

Any help will be greatly appreciated as I cannot seem to find what I am looking for, or as I said I might be getting too creative and just need to come back to reality.