I frequently receive an updated excel spreadsheet from our corporate office.
I've added a column to sort for local purposes. The concern being the
addition of rows by corporate so highlighting, copying, and pasting would
corupt my column by throwing off the alignment of the data.

Any suggestions on easily updating the information without "reinventing the
wheel"?