Hi, I am going to create a template for department budget, how can I easily
consolidate them all in one file with total amount after department manager
finish their respective worksheet on the template? Let's say, I have ten
workbooks with same format and layout that I get from different managers,
What tool I can use in MS excel to consolidate them to one workbook?

Thanks a lot,

Hank