Hello Again,

I'm trying to create a dynamic search box that encompasses different sheets in a workbook. I've been following this tutorial
HTML Code: 
and it has worked but it only works with a preset number of choices. The tables I'm working with keep growing. I thought about creating a separate sheet, lets call it "data" with "=A1" from the first source sheet. then do the same right underneath that one from the second source sheet starting at line 250 to support the growing tables. i have 12 source sheets. is there a way of creating an advanced search box in excel any other way? rather than copying 3000 rows of text hoping the 250 rows allow for enough expansion. Any assistance would be greatly appreciated.

Thank You in Advance