Extract data from multiple sheets
 

Hi,

I have 5 worksheets that contain lists of products and their sales. I have
a column that allows a user to mark if they want to 'drop' and item or 'add'
an item. I have another worksheet that is supposed to summarize all of
'drops' and 'adds'.

The data is set up like this:

Product, Sales, Sales/MM, ACV, Drop Product, Sales, Sales/MM, ACV, Add

I am more looking for a methodology that I can adapt to my dataset so do not
worry about exactness.

Thanks in advance for any help!!