I am trying to aggregate all the retail leases posted on The Real Deal. The first URL I am extracting from is "http://therealdeal.com/deal-sheet-2/retail-leases/1/" and the second would be "http://therealdeal.com/deal-sheet-2/retail-leases/2/" so on and so fourth. Any guidance into programming the VBA would be greatly appreciated.