Formulae changing when pasting numbers sheets to a new file
Hi all, I am new to spreadsheets in the Apple environment and really want to use numbers on my MacBook, .
I have one initial challenge to overcome.
Please excuse me if my terminology is incorrect, I will do my best...
Let's say I have a numbers file called "2022":
In this file:
Sheet "1" has numeric data
Sheet "2" finds the appropriate data from sheet 1 data and processes it, eg addition, percentages ect
Let's say I have a second identical file called "2023" with different data.
This file has sheets called "3" and "4" and functions the same.
Now, I want to combine the two files to make one with four sheets.
I want to combine the two files to further data analysis.
I can not select two sheets at once in numbers, so I paste sheet 3 into the first file (2022), no problem.
I paste sheet 4 into the file 2022, but the formulae change to pick up data from sheet one, instead of sheet 3.
Is this due to something I am doing wrong?
Is there a way to combine files that keeps the formulae mining data from the correct sheet?
Thanks
MacBook Air (M2, 2023)