VBA to loop through dynamic data validation list to update model

[eblaser_salessync]

How can I loop through 3 cells that each contain data validation lists, in order to update my model?
In order for the model I am working with to update, there are three cells (C3, C4, and C5 each containing a drop-down data validation list) that need to be cycled through in order for new source data to be incrementally added into our reporting. Currently, we are doing this by hand. For example:

C3: Select option 1 in list, wait for the model to update... Select option 2 in list, wait for the model to update... Select option 3 in list, wait for model to update... etc.

C4: (Repeat)

C5: (Repeat)

I am looking to automate this process and do not know where to start. I have looked at dozens of other similar requests (i.e. loop through list and copy/paste values in another sheet, loop through list and save as pdf, etc). However, I am not competent confused enough to reverse engineer those into a solution for this request.

THANK YOU!

 

[eblaser_salessync]

UPDATE:

Context for the situation

In our full file we capture performance data for clients and represent that data in reports that are comprised of several pages of charts and graphs (the reports live in the same file). Those charts are not updated automatically and require us to click through the various drop down lists to update our reports incrementally.

Example:
We've been tracking Jerry's performance over the last 4 weeks. At the end of week 5 we enter his raw week 5 performance data into Table A. However, our charts only show 4 weeks of available data because their source is Table B. Table A only feeds Jerry's week 5 data to Table B when we select "Jerry" in the data validation list in cell C5. Once Jerry's data transfers from Table A to Table B, it is there permanently, so we can move onto Elaine, Kramer, and George, then eventually the Location's dropdown (C6).

The Goal:
The following dummy file (https://drive.google.com/file/d/0B0zlbgkw1BSlUlpfN1pYOFBGams/view?usp=sharing) is a very very small chip off our full file but includes the basics of our situation and my a basic recorded macro title Refresh that achieves the basics of what I've been trying to find. The "Refresh" recorded macro imitates what we would do by hand. However, it is very inefficient because it does not skip blanks. Primarily are looking for help building out a macro that loops through either a) the names listed in the dropdown lists - or - b) the names in B51:B63 & B66:B71 while ignoring the blank cells. Ideally, the solution would be dynamic enough to house in our Personal macro workbook because we have use for this in about ~10 different models that are identical in structure (same worksheet names, same named ranges, etc) but contain different data sets (ie one may have 9 agents, and 3 locations, another may have 3 agents and 5 locations, etc).