Good-day

I am trying to use the drop down function across 39 sheets ...I am working on a menu list which is on sheet 1 (menu list)column B1 to B38.
I also have sheet 2 to 39 (recipes) which are the recipes for each menu listed in sheet 1 (menu list). In each sheet 2 to 39 column A2 in each of these sheets is the heading for the recipe that heading also appears in sheet 1 (Menu List)columns B1 to B38. I will eventually have all 38 sheets of each of these recipes tying into sheet 1 (menu List column B1 to B38). My problem is that I cannot get the drop down list in sheet 1 (Menu List column B1 to B38) to work. The source field requires that you input = and the name from the name box which you create on a different sheet( excel only allows one other sheet from my experience). I can create name boxes for sheets 2 to 39 in each of their columns A2 but the source field in the data validation section does not allow me to use multiple sheets i.e Column A2 sheets 2 to 39....Thanks