I found the simplest way to find the information was to use a SQL query, as I had too many modules/pages to search through manually.

SELECT TOP ( 1000 )

        ModuleDefinitions.FriendlyName AS Module_Name ,

        Tabs.TabName ,

        TabModules.PaneName ,

        TabModules.ModuleOrder ,

        TabModules.Header ,

        TabModules.Footer

FROM    TabModules

        INNER JOIN Tabs ON TabModules.TabID = Tabs.TabID

        INNER JOIN Modules ON TabModules.ModuleID = Modules.ModuleID

        INNER JOIN ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID

WHERE   NOT ( TabModules.Header IS NULL ) OR

        NOT ( TabModules.Footer IS NULL );