VBA open file, insert data, close file by tab.

Hello All,
Im trying to get VBA to open a file based on the name of a tab. Such as tab "Cabbage Cp" would open file Cabbage 2013, insert the data into the tab called "Cabbage CP", save file and close. I have to do this for multiple products on a weekly/monthly basis. It takes hours and sometimes a couple days. I figured with it being so simple, it can be automated. An help is greatly appreciated.