selections over workshetts

[#1]

Hello,

I have 6 worksheets and several boxes and charts per worksheet.

I want to select a value in a list and that should affect only to the lists on this worksheet but if I select a value in a different list

it should affect over all worksheets.

So an example:

I have on a worksheet 3 lists. On the first list I can select a date but this selection should only limit the table on this worksheet. But if I click

on the second list with names I want that all tables, charts and boxes from all 6 worksheets get limited.

Is that possible?

Thanks

[#2]

set up a trigger to clear selections on a specific field when you leave the worksheet.

[#3]

is it possible to save the selections in a varable that if I go back to the worksheet I can see my selections again?