Copy data from selected sheets to new sheet

Hi, novice in trouble
the attached workbook is used to monitor vehicle faults. I have built it up using bits of code gleaned along the way. Now the boss has decided he wants a button that when pressed will collect info from the sheets that display a fault at that time-and copy the first four lines to a new workbook which can be be printed - like an aged debtor summary. Unfortunately I do not know how to instruct the macro to copy the info if cell is not blank - or to ignore it if same cell is blank. Macro would have to be able to look into every sheet in active in active workbook. If anyone can give me a pointer in the right direction I can battle away from there. Boss decided he wanted it yesterday - wants it today. Any help appreciated. Many thanks, Nigel

Does this help?

Please Login or Register  to view this content.

Put the code in a module in the target workbook.