Hi everyone,

I have a workbook, with multiple Sheets ('2015', '2014' ...'2006') with the same structure in all of them. When I do a 'Find' and look for a customer Name in the whole workbook, sometimes the list of results is big. I would like to generate a sheet, by copying the entire row of every result. I mean, copying the row where customer FORD appears in sheet 2015, 2011, 2008 to a new sheet. I would have then a sheet only with FORD Information. It's like a multi-tab filtering. Any ideas ? Thanks, Rodrigo.