Index and match accross multiple sheets

Hi guys

I have two sheets which are identical (apart from the numbers contained within them) which I need transferring over to an “upload” sheet.

On the upload sheet I require it to list all sales/costs. I require a formula to look at sheet “1” and list all the occurrences of values listed in columns Q:S. Once is has listed all the values I then need it to list the same (all the occurrences of values listed in columns Q:S) but this time on sheet “2”.

I have uploaded an example of the sheet along with a example of what I require as I fear I have not explained this at all that well.

Can anyone help with the formula please?

Regards

Paul