Randomly select data from multiple sheets in Excel

I have data of various companies arranged in different sheets date-wise.

How can I select randomly any number of sample (say 10) where data can be extracted from any sheets with the condition that there is letter Y in the corresponding row in column "H".

In other words, I need to refer to random rows from random sheets with the given criteria and get the result of the values in a separate sheet.

Found a somewhat similar post here

Solution can be formula based but use of VBA is preferred as there is huge amount of data to be processed.

Please, guide me in the right direction.