Web Query for multi webpages

[aadilgillani]

Hi I am new to these great forums. I have searched but did not found any result to my problem.

I have a list of URLs and they contain adresses and details of Branches of a particular Bank. I want them all in an excel sheet.

the main site is

http://www.nbp.com.pk/BRNTWRK/DBranchFinder2.aspx

http://www.nbp.com.pk/BRNTWRK/Branch_Details.aspx?bCode=MDAxMg==
 
http://www.nbp.com.pk/BRNTWRK/Branch_Details.aspx?bCode=MDAxMw==
 
http://www.nbp.com.pk/BRNTWRK/Branch_Details.aspx?bCode=MDAxNA==

I ahve around 1300 URLs like this and want to extract data like this

Branch Name Main Branch Mirpur,(AK)
Branch Code 371
Address Main Branch Mirpur,(AK)
Phone 058610/42215 - 42621
Fax 43915
Tehsil Mirpur
District Mirpur
Province Azad Kashmir
Swift Code ---
Status Online
Email abc @ xyz.com