I have made a workbook to keep track of client data for our firm. On Sheet1, I have multiple sections of data, e.g., Assets, Liabilities, Insurance. Every year we have to update clients' information and so must first copy over last year's data to a new workbook and then update values.

My question is this: While I know how to copy values from one workbook to another when the data ranges are static, I'm not sure what to do if the position of the data changes. Why do things change? I'm constantly making adjustments to the workbook to improve functionality, and while I could wait until I'm "done" before using it, this would mean we'd never use the workbook.

I can't be the only person with this problem. I wonder if anyone has any suggestions? Much appreciated.