Copying info from Tab to tab

[DRRPhoto2024]

Working in a MAC environment, Excel V 16.77.1

I have a budget spreadsheet w/multiple months, each represented by a tab.

I'd like to copy form the previous tab (month) to the current so I can see gain or loss month to month. 

In Jan I set up copying from Dec so that was great.  But now that I've copied all the data from Jan into the newly created Feb tab the copied info is still coming from Dec.

Is there a way to reference the immediately previous tab so it will always copy the immediately previous month?

Thank you!

[#2]

@DRRPhoto2024 

From what you've written, I'm assuming that this budget spreadsheet is a new one, begun in December, set up for January to copy from December showing increases and decreases. You're having difficulty now with the February one. If that is right, if in particular it's correct to have understood this as an early effort at budget tracking, may I make a suggestion?

Re-design.

Don't have a separate tab for every month. Keep all data in a single database. Excel is really good at developing summaries of such things as expenses by category by month, working from a single transactional database.

You are doing this in a way that would have made sense if you were keeping records on paper. But you're not keeping records on paper. You're using Excel; but you're not using Excel well.

Would you be willing to share a copy of the workbook you have so that I (or some of the other Excel experts here) could take a look at it and make suggestions as to how it could be improved to take more complete advantage of Excel? Post a copy of the workbook on OneDrive or GoogleDrive, and paste a link here that grants access to it.