VBA Procedure too large error

I am using the VBA code for importing HTML data in Excel Sheet based on the cell value. For each row, I am using repetitive code. This code is working fine up to 94 rows and after 94th row, it giving error VBA Procedure Too Large. I want this code to work for more than 600 rows. Please help. Sample sheet is attached.