Lookup Data from Mulitple Worksheets (approx 100) - into summary sheet

Hi

I have a workbook with approx 100 worksheets, with various bits of supplier information, Total Support Value (£), Annual Agreement (Y/N),
i have many more fields to populate but if i can get one reference to work i can the hopefully then populate to the other needed fields.
I've attached a very basic example of the workbook i'm working on, but the principle of the task is on their. All worksheets are in exactly the same format.

Rather than go through a very long process of manually linking the cells to the specific worksheet if there is a way of lookup / index MATCH versus the 100+ worksheets it would save me a huge amount of time.

I have a Macro which strips out the supplier names into a results worksheet so all suppliers are within the summary worksheet (Column A), so i know that the reference names will be right? I'm still only very new to VBA and havent had much chance to really play with it too much yet.

Any help you can through at this would be fantastic and save me what may take a week to populate otherwise, once i've finished it for this manager i have another 5 to do!

Many thanks in advance!!
Adi

thanks in advance!!!

thanks, didn't think of INDIRECT, not a formula i use very often, but that works a treat, a bonus that i dont need VBA as well, i try to avoid it as much as possible with our Citrix servers massively disliking them!!

I'm in retail on the trading side so its all relevant to budgets and contracts.
One thing i could request, the columns are different, one bit of info would be F7, another G30, how can you adapt the formula to be a little more flexible?

Its okay, i've got it sorted, and reversed the value to give me the figure in an Accounting book-keeping format
=-INDIRECT($A2 &"!$N$3")

JieJenn, thanks again, it has saved me several several hours!!!

Adi