Thanks in advance if someone can give help,
below I try to explain what I need
I have a workbook made of many worksheets ( each one has the same template, see Picture 1).
I would like to use one of the worksheets as an interactive dashboard to build customized report ( see Picture 2 )...I mean that after populating some input fields (F9, G9, F10, F11 and G11..all or JUST one..two..) by clicking a button a macro will read recursively on every worksheets and will write down row after rows the datas found on every column of each row that match (contain ) the setted search criteria. A second button 'reset' will clear the input fields and the entire extracted data collection.
Es. if I put in F10 2019 05 01, in F11 2019 05 31 and in G11 Cambiellus then after the macro run I will find starting from cell F13 (Prog. 1) every data found plus
in N13 the Customer name found in C1 of every template
in O13 the ID ref. found in D1 of every template and
in P13 the Description found in E1 of every template
thanks in any case