I have 20 workbooks that are used for forecasting, so they all contain the
same layout. I need to pull from each file and consolidate based on the
PRACTICE column and provide each Practice manager their details. example:
Security, BSO, Clarity, etc.....

I need to be able to have 1 conoslidate file for each practice to show the
current forecasting.

What would be the best method to pull & consolidate this type of information
on a weekly basis.