Hi all, I am new to the forum and I need help revamping this sales report.

The current sales report format is with the summary as the first tab, then each of the company's products as different tabs, with sales number broken down by month and year within.

Now over the years, the sales report has retained the discontinued products while we are constantly adding new products. So now the report has over 30+ tabs! Which makes it tedious to scroll through, find the right product and then updating the monthly numbers manually.

What I had in mind revamping the report is, having only 2 tabs in total, first one is the summary while the second one has an empty array with a drop down menu of all the products. When somebody selects a product from the drop down menu the sales number, by month and year, will be shown in the array which also allows me to input and update it.

Is this possible or is there a better way of organizing this report?

Thanks.