Scraping Data using VBA

Hello. I am an intermediate Excel (2007) user and I wanted to know if I can use VBA to assist with a project I am working on for work.

There are several intranet sites in which we house our worksheets. I would like to be able to scrape specific cells from one workbook (individual worker sheets) to another (overall sheet). Right now, there are IF formulas setup to scrape the information needed but I don't know if these are the best to use. I would like to be able to change the worker's last name and the month from the drop down lists and have the other information auto fill correctly.

Can anyone assist?