I recently started an new job and the boss asked me to clean up and reconfigure some lists and worksheets. I have a lot of worksheets that need to auto populate a master list. These worksheets have been in use for over a year and while I know how to share specific cells I do not have any idea how to tie these worksheets to one master list and have them populate it. I'm willing to start these over from the beginning and I have plenty of time but I was hoping there was an easier way. All the worksheets are in the same workbook and we are using the 2010 Excel. The worksheets are for assigned inspections and once the inspectors input their data it needs to populate one master list. If anyone can point me in right direction I wouls be grateful.