I'm Sorry, I can't. I actually don't have what I was working on since it was so messed up I just deleted it and started with the one I had saved that was just 1 back from what I was trying to change. I figured out what was wrong, I think. So, this was the problem: I don't really understand how the 'internal' excel is working, so I had no idea how the inserted Tables, The Name Manager and such are kind of linked and interact, when I was trying to split out the tables on 3 different worksheets, I copied the inserted tables worksheet using the control and mouse to drag, then renamed the worksheet and then deleted all but the tables referencing owners, then went back to the original table worksheet and did the control drag again, and deleted the tables on that page that didn't reference income, and then did the same thing again for expenses. Then I deleted the original tables worksheet. But what I was seeing in the name manager, I couldn't figure out, like Table25, 26, 27, I didn't have 27 tables, {hee, hee, hee, but I did }.

Anyway, I went back to the older workbook and late last night and got it done, probably not as easily as it could be done, but it works and I do now have my 3 separate table worksheets and only the original 9 tables in the Name Manager. I also learned last night that if you copy a worksheet from one workbook into another workbook [I copied a summary sheet] the formulas in that sheet in the new workbook began =SUMIF([OLD_workbook.xlsx] and rest of formula, which told me that the sheet was linking back to the old workbook

So thank you for your interested and willingness to help me. If you know of a place that explains how excel is working [internally, I don't know how else to express it], that is how the worksheets are interacting and such, I'd would really appreciate the information. Thanks again, have a great day.

Ruth