Hi,
I have a file with multiple worksheets 1 work sheet for a summary and the
other worksheets are my quarterly. In my quarterly worksheets I am always
inserting columns to add P.O. orders to a customer's account, but out to the
end of each customer I keep a total running of their account.

My problem is on the summary page. I want to be able to show each
customer's current condition in the summary page, how do I get their totals
to always show up when their totals on their individual worksheets keep
moving to a different column?

for instance worksheet one is my summary page cell B7 would show the total
from worksheet 2 H5, but next week that total from worksheet 2 will be in
cell K5, is there a way to make my summary cell keep track of the correct
cell on worksheet 2?

Sorry if this is too long or confusing.