How to use Excel Vstack Function for Automatic Update from Multiple Sheets

How to use Excel Vstack Function for Automatic Update
In this video, you will learn a new function in Excel Office 365 which is called "vstack" function. Excel vstack is used to append arrays in vertical manner. You can combine data from multiple excel sheets. I will give you two examples The first is when you vertically stach data without update and in the second example, when you vertically stack data with automatic update.

[@pragatisawant1724]

i m not able to find vstack function in my excel 2016 what are the steps of that?

[@digitidea]

I explained