That is Exposé. You can show all windows and click one like you described, hide all windows, or show only the windows that belong to the active application. You can set what key you want each of the actions to occur in System Preferences under Exposé and Spaces if you are runnning Leopard, forgot were it was in Tiger.