Hi all,

I need some help with something

I have an excel spreadsheet that has multiple worksheets. The first worksheet is a summary page and the other worksheets are named by state.

In my summary page I have information that will change from month to month but the header names will stay the same. So what I need is a way to go to the "State" column and read the cell for what state is there and then find the worksheet with that state name, then back on the summary page go to the "County" column and read the cell for what county is there and then find that county name on the worksheet for the state that we found and then grab the "fee" cell from the "state" worksheet and put it in a cell on the summary page.

Can anyone make sense of that, i'm sorry if that is confusing, hopefully you get what i'm trying to do Please help