如何为多个标签进行网页报废

I am trying to extract "href" link form a webpage to my excel sheet based on the value available in sheet. I am successful by doing the same for one value, but I am unable to loop the same.I am trying to extract "href" link form a webpa