Google sheets, collect data from cell from all sheets?

Question

Google Sheets

Good evening, I ran into a problem, you need to collect data from a cell from all sheets in Google spreadsheets, there is an option to simply list them through; but sheets 300-400, and further scaling, tell me which way to look?

Answer 1

API

Answer 2

We need a script
With one cycle we run through all the tabs, with the second cycle we collect all the values ​​​​from the tab.
As a result, paste the result where you need