Data scraping from multiple web pages into Excel with macro

This is not first time this is question is asked on this site. I wish to extract many sites into one Excel file. I have been searching a lot on the web and seen youtube vidoes, but can still not get it right.

I am new to any form of coding and have not any experience with this. What I seen it is possible to make a macro in Excel to do the work for me, but cannot make the right macro.

I need help to make a macro that could work for me. The following site I try to scrap into Excel is:

http://ift.tt/2lcQfS7 …. etc http://ift.tt/2lhUiJM

All the pages from 1 to 2295 into same page in Excel. Any other suggestions are welcome. I just need to get it in Excel.

Thanks in advance!