Sync Data of 2 Google Sheets

How to merge Google Sheets data

As everyone is working from home, we are suppose to make reports and presentations so we tend to have a lot of google sheets with various data in each and so this was a problem faced by me as well, so thought to fix this using some google functions. I came across a function which connects 2 or more than it with one single spreadsheet where all your data is present.