I have a database spreadsheet file, that I use to calculate coordinates, it's basically a huge file with a couple math formulas. This file size is 4.5 Mb

And daily I create spreadsheets that hold other information, simple sheet. this file is 500kb.

My routine is I open spreadsheet 1, find coordinates, save them. then create spreadsheet 2, add coordinates, populate the rest and it's done.

This takes me opening two files. I've also thought about adding the database to the new files every single time but it would quiclkly fill out my online cloud storage.

I'm wondering if there's any way to reference the 1st spreadsheet from the 2nd without having to open the file? I just need access to couple cells. from spreadsheet 1

Input cells to insert indexing coordinates.
and outputing cells to pull out result from the index.

Hope this makes enough sense.