Hi

In 1 sheet have 20 tables of holding the same except for col 1 in each that
hold a unique id for that table. Each table can hold up to 50 rows, so some
cpuld be blank.

I need to produce a specially formatted report that will allow me to select
the unique ID from a drop down and so only that data will be listed

format of table data

ID | Name | R | B | S | X | L1
pc001 colin 200 2 1 1 5

I will insert the same format into the report.

As an add on I have 12 of these sheets each holding 20 tables so it would be
wonderful if I could have 1 report that has a drop down to select the sheet
(each sheet is name after a calander month i.e. jan) and then a drop down to
select the ID. But then I want to win the lottery as well. :)

many thanks

UKMAN