I am quite familiar with Excel and VLOOKUP (I made my living programming in Excel long before I got involved in Access).
I am still a little perplexed by your Excel setup. So do you have a separate lookup table for each and every "Source" (China, Brazil, etc). It would probably work much better in Access if you had these "Sources" as one large table, and have in this table named "Source" that has these values (China, Brazil, etc). This would create a linking field you could use to connect your tables.
To best utilize Access, it is important to understand how Access works. It is a relational database tool, which means you have various tables which are "connected" or "linked" by common field(s). If there is nothing in common to link them on, I don't think you will gain any advantage to doing it Access versus Excel. Also, Data Normalization is also an important factor that can come into play with Access. If your tables are not designed properly, you are probably going to create a lot of frustration for yourself. My first dabbling in Access was to create a billing database, and I spent months on it, only to have to go back and educate myself on Access and re-start it all over again.
It may be best to take a step back here. If you already have something in Excel that works, but is not quite automated to the way you like, and you really aren't proficient in Access, you might be best to keep it in Excel and look for help with the automating piece.
What is it that you would like it to do in Excel that it does not do now?