I have in the Row Source A1:A150. It will not let
me add anything else like you suggested Sheet1A1:A150.

You missed the exclamation mark (bang symbol) between the sheet name and the
range address...

Sheet1!A1:A10

--
Rick (MVP - Excel)