Hi again Excel 2007 boffins.

I have multiple worksheets within a workbook each tab with custom names that
each contain specific contract data.

I have a summary page but all summary data is generated manually by my using
'=' then clicking specific wooksheet tab, clicking cell and 'enter'.

My data in the worksheets is not arranged by column headers.

Surely there is a formula likely built around vlookup that could make this
less manually intensive.

Thank you.