Prioritized to-do items on separate worksheets feed into master worksheet?

Howdy.

Using: Excel 2002 running Vista Home. Experience level: programming newbie; used Excel for business several years; have only used the most common dozen formulae algebraically hierarchized; about 25 years ago, built simple macros for wordprocessing functions.....

I would like to create prioritized todo lists for individual projects on individual worksheets that I will call "slave" worksheets. Then I would like to be able to call up all of those priorities todo items into a single, "master" worksheet, all sorted according to priority.

The question may be clear, but let me give an example. Each of the three worksheets features two columns; the first column contains a number representing the priority, the second the todo item.

The Gardening Worksheet (slave)
PRIORITY / ITEM
1.5 / Buy soil
2.5 / Plant seeds
3.7 / Water

The Art Gallery Curating Worksheet (slave)
1.2 / Buy Gallery
2.0 / Hire Curator
3 .5 / Purchase Picasso

The Master Worksheet (master)
1.2 / Buy Gallery
1.5 / Buy soil
2.0 / Hire curator
2.5 / Plant seeds
3.5 / Purchase Picasso
3.7 / Water

I presume that, since this is not a relational database, data would only flow one way, i.e. from the slave worksheets to the master worksheet. If I were to delete an item from a slave worksheet, it would change on the master, but not vice versa.

(And if I did want the data to be "relational" in this way, could I do it in Excel, or is there another program that could do this fairly simple function?)

Thank you!

Yours very truly,

Le Neveu

P.S. Don't worry, the Picasso will be okay if I water it!

If you abandon the idea of using separate sheets it is easily and efficiently done on just one sheet using functions.
On the attached doc the 'PRIORITY TIE BREAK' column, column D, ensures that items with equal priority are shown (in order of appearance in column C) instead of repeats of the uppermost item with the tied priority. Also, this column could be hidden.

Dear BeauNydal,

Thank you for your thoughtful reply. I neglected to mention my reason for organizing a todo list this way. I guess I have two working phases. The first phase is planning, the second is executing.

For the first phase, I'm working on several different projects and want to be able to focus on only one project at a time when I create a todo list for it. Hence individual "slave" lists.

For the second phase, I want to be able to get an overview of priorities for all my projects--hence the master todo list.

A couple of months ago I came up with the attached solution: I can order todo items by both color-coded project categories (and sub-categories) and also by overall priority, depending on what I sort on. This may end up being the most efficient approach--still, I feel that my planning for each project could be more focused if I were to use individual sheets--kind of like breakout budgets whose data feed into a master budget.

Thank you for your consideration.

Yours very truly,

Le Neveu

Assuming you want to stick with the multi-sheet format here is a simple vba version.
The code is a procedure in the Master sheet code module.
Right-click the Master sheet tab then choose "View code" to see the code.
It runs when the Update button, on the Master sheet, is clicked.
It first clears the old list then pastes each other sheet's Priorities and Items into the Master sheet. Then it sorts the new list.
My VBA is a bit rusty, I hardly ever use it.

Beau Nydal