I have a workbook with several sheets:

07.1
07.2
08.1
08.2
08.3
08.4
09.1
09.2
09.3
09.4
09.5
09.6
10.1

They all contain data layed out in the same way

A - Invoice Number
B - Level 1 Address
C - Level 2 Address
D - Level 3 Address

The workbook is titled: Timesheet Summary March 10

Now in a worksheet I have used vlookups which work like this:

=VLOOKUP(b2,'[Timesheet Summary March 10.xls]07.1'!$A:$D,2,FALSE)

This works for the info I need but has to be manually done for each sheet which is very time consuming (I also have to run it twice more to return 3 & 4 in other cells)

Is there anyway of running this once so it checks all worksheets withing the workbook for the information?

I have tried using a couple of VB varients I saw aftr a search but none seem to work (I am likely doing something wrong) and throw up errors in VB even when I copy and paste the formula just changing the ref to my sheets.

Any help would be greatly appriciated and timesaving over the next few months.