Getting data from all sheet into one sheet

[neeraj2050]

Greetings!!

Is there any way to get the data from all sheet into one sheet. (Note: In every sheet columns and formatting is same).

Non VBA solutions will be appreciated. However, VBA solution is also welcome

Regards
Neeraj Kumar Agarwal

 

[chirayu]

You could use the INDIRECT formula to do cell references but VBA solution is better as it wouldn't require user input to change range etc

 

[neeraj2050]

Can you please suggest the way to apply indirect formula

 

[chirayu]

Sample attached. Tutorial Links below

http://www.contextures.com/xlFunctions05.html
https://www.ablebits.com/office-addins-blog/2015/02/10/excel-indirect-function/