Collecting values from different worksheets according to a certain condition

[pjmv]

I’m sure this is possible but I just cannot figure it out.

In a workbook I have several worksheets. In these worksheets the same range (for instance B2 to F10) is filled with values. Let’s say numbers from 1 to 9.

I need to create a new worksheet that collects, in the same range, the value if it’s present in any of the worksheets. For instance number 1: this new worksheet will show me a global vision of the cells that have 1’s , leaving blank the ones that don’t.
It will need to do the same for the other numbers, of course

Thanks in advance

 

[MickG]

Try this:-
https://app.box.com/s/c2mclp13v1bqlyny69kuczkxmy3rq3rf