Is it possible to export a simple Numbers spreadsheet while being dynamic?
No, PDF exports of a numbers file become static and can no longer be edited as a spreadsheet. You must use the Numbers program (or an equivalent like Excel) to achieve the dynamic features of spreadsheets.