Is it possible to Add Columns into the Middle of Existing Linked Data?

Is it possible to Add Columns into the Middle of Existing Linked Data?[Solved]

I have just completed several workbooks. They are usable, but now we realize we needed more data than we currently have. Several of the workbooks are populating data from each other. Is it possible to add additional columns into the middle of the existing linked data without messing all the links up?

For example, the Factory Sales Order. They want to add a three digit customer ID into the beginning of the Sales Order worksheet, but that would mess up all the workbooks pulling the Quantity Shipped.

Any help would be very much appreciated.

Thanks,

Thank you!