I am new to excel. I am currently building an extension to my property and wanted to create an excel file to keep track of the costs. I can do the simple one-page sheet that totals the amounts at the bottom, but what I would like to do is to also keep track of expenditure with each supplier on a separate sheet. Is there a way to do this automatically?? Do I set up a sheet for each supplier then use a formula to collate all of the sheets onto one separate total cost sheet? or can I enter all expenditure on one master sheet and create a formula to extract the data automatically based on supplier??