Using multiple criteria, extract data from multiple sheets into one sheet

Hi Every One!

Can someone help me solve my two issues?

First, Match multiple criteria's in different sheets and extract the data from many sheets to one sheet. Secondly, If the search criteria finds a repeated matching criteria's , then the evaluate formula should pull the max of it.

In the attached sheet, I specify the data that I want to extract, And what criteria will be applied to which sheet?

Hi Kaziz

Try the code below for the first issue

Please Login or Register  to view this content.

Hi excelxx...

as forum running very busy....thought my thread is ignored... asked similar question in another forum...received answered to many questions.

And all of sudden, I realized, my thread had been answered ....Thanks a lot for the coding....I run your code....receiving, "Sub or Function not defined"

I got two codes from OzGrid forum to get same results. but the issue is in Display sheet columns AQ to AY is not producing any results.

I would be grateful if you could help me in this regards and bring up the same results.

Please Login or Register  to view this content.

and second code.

Please Login or Register  to view this content.

Hi....

Can anyone help me combine the above two codes?