Macro for extracting data from multiple sheets if cell has text

[plasma33]

Hi there,



I have a workbook with multiple sheets each containing prices (and other information) for certain products. You can call this workbook as a price book. I need to extract data from multiple sheets onto one sheet called "master". But the issue that I have is I need the data to be extracted from only the specific cells that have text in it from multiple sheets. I am attaching a workbook for your reference. In that worksheet, Price1 and Price2 are the sheets from which I need to extract the information. "master" is the sheet where I need the data to be extracted. Sample data is provided within the attached worksheet. Can I get VBA code for the requested, please?

Thanks in advance.

Plasma33