Hi All,

I have a workbook with about 8 tabs. This all contain a list of staff
members and months of the year. Each tab is for a different performance
indicator (minutes late, errors, handling time etc).
I'm trying to create a summary tab where I can enter the month in a cell and
have only the data for that month from each tab copy to this tab.

Does anyone have any ideas? I have seen this done before.