Working with data on Google Sheets.
You'll know how powerful google sheet is
I could use the following functions :
1 . IMPORTRANGE (spreadsheet key, range_string) and
2 . IFERROR(A1,"Error in cell A1")
Here is some example for you: