Multiple Loading Data Command Buttons and Formulas using a macro.

Hello Everyone,
I am needing a little help with a project i have, if anyone of you could read over what i have written below and try to help me out with this one. Thanks in advance. I have attached 2 documents needed to understand this project.

Start with the "Raw Test Data" named sheet, what i need to do is get the"Get Raw Data" Command Button to pull raw data from any file and paste values exactly the same as the source workbook it comes from onto this current sheet.
Next is the "Offset Data" named sheet, what i need to do is get the"Get Offset Data" Command Button to pull raw data from any file and paste values exactly the same as the source workbook it comes from onto this current sheet.
Now on the "Test Data" named tab is where i need the work to show. I need this sheet to do some calculations as information is input into the previous 2 tabs. I need a macro to automatically do the formula's for more and post them to this sheet. I have 6 set of difeerent data listed as VbX01, VbY01, VbZ01 for these 3 data points there are 32 of each one which i need averaged out and placed in a cell which i will mention later. After these 32 data points there is another set like SX01, SY01, SZ01 and the same for these which is 32 data points each. I would like these 6 data points to be average with each other. The following formula is how i need the outcome to be posted on this sheet. VbX starting in row 2 column E, then VbY would start on same row but next column F and then VbZ would be on same row but next column G and the same would go for SX, SY, SZ the column would continue on from the last and row would be the same. The below formula is what i need each one to be calculated before placing the data on this sheet.
DATA FORMAT (18 Sept 2015):

VBX_g = (VBXaverage - VBXoffset) / VBXscale
VBXoffset = 0
VBXscale = -260 …. Note: there is a negative sign.

VBY_g = (VBYaverage - VBYoffset) / VBYscale
VBYoffset = 0
VBYscale = 260

VBZ_g = (VBZaverage - VBZoffset) / VBZscale
VBZoffset = 0
VBZscale = 260

SHX_g = (SHXaverage - SHXoffset) / SHXscale
SHXoffset = 0
SHXscale = 20

SHY_g = (SHYaverage - SHYoffset) / SHYscale
SHYoffset = 0
SHYscale = 20

SHZ_g = (SHZaverage - SHZoffset) / SHZscale
SHZoffset = 0
SHZscale = 20

If i didnt answer any questions to go with this please let me know and i will answer them. This might be a little confusing so i will try to explain them as easy as possible.

bump............

I could really use some help with this one please.

Yes this is the correct formula for VbX. If you get this one then the others will be the same concept.

Sorry forgot to answer some of your questions mentioned above.

is sheet1 on test.xlsm what you want to end up with?
Very similar on the setup of it yes but not exactly if i need to do an example sheet of how i need it setup i can but i tried to explain the setup the best i could.

where does the offset data come from? did you forgot to attach that file?
It will be similar to the same file i attached and i need to be able to open it up from a destination like the other tabs. It will be laid out in the same format as raw data and will need to be interchangeable just like the raw data.

Awesome! This worked for the first part of what i needed. Now i need to be able to load another raw test data on the offsheet tab. Basically load just like the first tab does. When i try to load it off the offset data tab it does nothing. What i need it is to place the values on this sheet just like the raw test data one does.

I will reattach the 2 documents here. One will be the Test (2) which has the offset tab i need to pull data from a file on my computer and the other is the file i need the data pulled from.

bump..........

Okay so I've looked over what i had and decided to re-instate what i am needing this file to do. I have attached files to work with this time have some comparison files also.

Main File : Test File 1

I need all the work done on this workbook

Raw Test Data Tab

1. Need to select the command button labeled "Get Raw Data".
2. Next need it to open a file on the computer and paste its values on this sheet identically.
3. I have attached the files "Raw Test Data/Offset Data - Offset Data/Raw Test Data" to be loaded and pasted on to this sheet.

Offset Data Tab

1. Need to select the command button labeled "Get Offset Data".
2. Next need it to open a file on the computer and paste its values on this sheet identically.
3. I have attached the files "Raw Test Data/Offset Data - Offset Data/Raw Test Data" to be loaded and pasted on to this sheet.

Sheet1 Tab

1. For some reason i cannot change the name of this tab or it will mess up what is going on with this macro. If i could get the name change i would like to rename it "Final Data".
2. Need to select the command button labeled "Get Test Data".
3. Next need it to open a file on the computer and paste its values on this sheet identically.
4. I have attached the files "Sheet1 Data 1 / Sheet1 Data 2" to be loaded and pasted on to this sheet.


The problem i am having is getting each tab to load these files independently. Example : If i was to try and load a Offset file then it only changes what is on the Raw Test Data tab. The same thing goes for the command button on Sheet1, if i select a different file it only changes the Raw Test Data information. I had a lot of help with the code already so i am unsure of where the problem actually is. If someone could please take a look at this and help me out i would really appreciate this. If there is anything i can explain or i missed then please let me know.

bump..............

Could really use some help with this everyone. Any questions just ask.