I have an Access database that I use to update reports. The database consists of about 30 Nursing units. I use an excel file, with a worksheet for each unit, to organize the data to enter into the Access database. There is a data collection sheet that is the main source of the data. I have a worksheet for each unit, that uses VLOOKUP and different functions to pull that specific unit's data. I was wondering, is there anyway I can link the worksheets to the form I use to enter the data for each unit, instead of manually entering the data for each unit? Or does anyone have a suggestion to make this data entry process less tedius? Thanks in advance!