![](https://d3vm0xy31f4bap.cloudfront.net/wp-content/uploads/2022/03/Untitled-design-1-37.png)
Add Your Doubts: Click Here
Summary: In this video, Mr. Raj Singh Sir will teach you how to use CONSOLIDATE Formula. We will learn how to take data from two different sheets and post it on a single main sheet. Any changes made in the other sheets will be reflected in the main sheets.
Process: Click on the DATA TAB > then go on CONSOLIDATE (FUNCTION, REFERENCE, AND ALL REFERENCE)
Tick all the checkboxes below
Conclusion: In this video, you learned how to make a Master sheet out of many sheets.