Hi people, i am a birdkeeper and am trying to set up  a workbook with various spreadsheets that relate to 1. an id 2.a pen number  and various other entries for each bird. On my Birds spreadsheet i have a colum named Pen and within the same workbook other spreadsheets named Pen1,Pen2,Pen3 and so on.