complex substitutions

I have 4000 numbers to substitute in turn (and store the result) into a an entry cell which itself feeds many other cells and their formulas to produce a result cell. Data Table doesn't work. Any ideas about how to accomplish this? D