What is the best way to continuosly update on workbook with information stored on 13 workbooks with a total of 61 worksheets.

I have inherited someone else's tracking system. They have a seperate workbook for each account that we pay bills out of and a seperate worksheet for each sub account.

Now I am entering the info into the main workbooks and copying and pasting the same info into a combined workbook.

Isn't there a better way. Can I set up the combined worksheet to feed off the exisitng worksheet?

Thanks I am truly baffled on this one.

Rheia