how to build a dashboard in numbers

Can you be a little more specific, you can create summary tables, charts, etc... On one sheet with other sheets holding your raw data. Is that what you are looking for?

jason

And for ideas check out the templates (File > New), in particular 'Running Log', which has many aspects of a dashboard that you could adapt to other purposes:

SG

Is there a way for numbers to dynamically consume a data set which is regularly changing, without having to import the file and save as a static file everytime?

Thanks