Hyperlink between sheets in same workbook
 

I am trying to access sheet "B" from sheet "A" where via a hyperlink where
the values in sheet "B" are updated based on the specific hyperlink selected
in sheet "A". For example, clicking the hyperlink for "Miami" in sheet "A"
activates sheet "B" places "Miami" in cell A1 and the sumif formulas populate
the sheet. Basically, multiple hyperlinks calling one sheet and changing the
values based on the hyperlink range.

Thanks!