Getting data from multilple work-book through particular one cell

[Ravindra]

Dear All,

First of all, I would like to pay thanks to all of you who helps here and share their valuable time to a needed person. Today, I have one query what has been given below:-

I want to fetch data from multiple work-book through particular one cell. For example:-
I have three sheets name Jan,Feb,Mar and now I want to fetch value of cell A2from sheet1 through all given sheets in a new sheet which name is MTD. For better understanding I have enclosed sheets here kindly find it.



Thanks & Regards,
Ravindra Bisht

 

[Luke M]

I think you switched your terms "workbook" and "worksheet" a few times. As it's easier to work with one workbook, I've put all worksheets into a single workbook, and then used a 3D formula to combine all the data. If this is not correct, can you please elaborate on what you would like to see?