Hello All, I need help to extracting data from multiple sheet. i know only extracting value from a particular range or cell. but how to extract if a client have one or more information. FYI,see the attached. Awaiting for response!!