Drop List Selects that display values of specified months

Hello Everyone,

I am looking for some help to identify a formula that I can use to display values of a specified cells.

I have a spreadsheet that I use to track my monthly credit card balances. However, it becomes a pain to change the formula in every cell for the data I want to see. In the sample spreadsheet I have attached, I input a balance for a specific month in worksheet tabs Card 1 - Card 3.

I would like in the summary tab display the value for the month, when I select a month from the drop down, in the fields besides Card 1 - Card 3. So if I select Feb in the drop down list, I would like to see the balances for Feb in summary tab, and if i change the drop down to Apr, I will like to see the balance for Apr in the summary tab.

Can anyone help with with this request.

Thank you very much in advance

Roy

Thanks FDibbins, that worked like a charm.

Many Thanks.

Roy.

One more question FDibbins, what if I throw a complexity into the equation.

I would like to retrieve values from a specific cell and populate the columns.

For Example, select charges for the month of January and display it in the Charges column in the summary tab and select paid for the month of January and display it in the Paid column on the summary tab.

See attached spreadsheet

I really do appreciate your help, I am learning in the process.

Thanks FDibbins, that worked. I did not realize that 2,0 was part of the VLOOKUP formula, which I am familiar with. My spreadsheet is ready and I very happy with it.