I am taking data from Google Analytics into a monthly report in Google Sheets. I have one sheet which pulls in the data which I plan to run at the end of every month. The data I am pulling through is visits and conversions for a number of site URLs. I would like to show month on month data so was planning to have another sheet which takes this data and displays the values per month so it's easy to compare.
My issue is that when I re-run the report it would update each month rather than the latest month.
Is there any way to make a cell in one sheet pull through data from another but not auto-update afterwards?