I am working with a really detailed excel sheet... its a eBOM for auto components to be exact... I want to pull out information from the different components that we are going to make (length, width, height, annual volume and press size)... I want to automatically pull out all that informaition and place into a template that i created instead of having to type it in manually.. I want to use the same template and automatically upload the information once a new eBOM is loaded into the workbook... Can this be done? thanks in advance!