Macro to save workbook - Create Directories / Sub-Directories Based using text in cells

I have very limited knowledge of VBA, but haven't been able to find code examples of exactly what I want.

I have a workbook with a worksheet named "Data Sheet." Multiple users will open up a read only version of the workbook, enter some data on the "Data Sheet," and then hit a Macro Button that should:

Check to see if a Directory & Sub-Directory exists (I really don't need to know, just trying to avoid errors),
If not, create the applicable directories and save the workbook in the directory.

I will have the following Cells contain text to be used for the directory and file names:

T40 = File Name (e.g., Japan 01-20-2014 John Smith)
T41 = Directory (e.g., FY14) "Fiscal Year"
T42 = Sub-Directory Name (e.g., Japan)

So, if my hard drive just has the directory G:\Everyone\Travel Unit\Foreign Travel\

I want to run the macro and it would ultimately save the file as G:\Everyone\Travel Unit\Foreign Travel\T41\T42\T40.xlsm
or G:\Everyone\Travel Unit\Foreign Travel\FY14\Japan\Japan 01-20-2014 John Smith.xlsm

If found some pre-code that looks like I should stick in front of it to ensure that certain cells have been filled with data before saving. That is:

Please Login or Register  to view this content.

Any help would be greatly appreciated..