This video shows you how to use the consolidation template that has been developed and is free for download at the FinanceLearningAcademy.com Give it a go and let me know if this helps.