Automatically Transfer Data from One Spreadsheet to Another

[airetam]

Hello!

I am very very new to Excel and need assistance with transferring data from on sheet to another....please be patient with me

In a nutshell, I need to have 3 columns of data from 4 separate spreadsheets automatically transfer to another "master" spreadsheet.

The data contains "Date" "Mileage" and "Explanation" within each spreadsheet. I need this data to automatically transfer over to a "master" spreadsheet that will provide a total amount of mileage owed.

Date: A18:A29,A38:A52,A61:A75
Mileage: R18:R29,R38:R52,R61:R75
Explanation: T18:T29,T38:T52,T61:T75

The above values are also the same for each spreadsheet (total of 4). The "master" spreadsheet would need to capture the data entered for each value from each spreadsheet. So basically if data is entered in rows A18, R18 and T18 in Sheet 1 and A18, R18 and T18 in Sheet 2...etc, then it would automatically transpose to the "master" spreadsheet on the first available row...and so on and so on.

How can I make this work?

I hope I'm explaining myself clearly. As I said, I'm very new and don't know the terminology that well.

Any assistance would be greatly appreciated!

Thank you!

Mitchell

 

[FDibbins]

1st question...
Do you mean that you have different tabs (work sheets) within the same file (workbook) that you want pulled into another tab (worksheet)?
Or do you have a tab (worksheet) in different files (workbooks) that you want pulled into another file (workbook)?

 

[airetam]

1st question...
Do you mean that you have different tabs (work sheets) within the same file (workbook) that you want pulled into another tab (worksheet)?
Or do you have a tab (worksheet) in different files (workbooks) that you want pulled into another file (workbook)?

Hello Ford,

Thanks for your response. I have different tabs within the same file that I want to pull into another tab within the same workbook.

Thank you,

Mitchell