Plot graph for complex equation based on a range of X values

I have a fairly complicated equation that has only 1 variable but a change in that variable affects about 30 different values (on a number of different worksheets). It is not practical to rewrite the equation on a single worksheet.
Is there a way to plot a line graph based on a range of x values (e.g. 1 to 1000) without having to recreate my equation?

Thank you MrShorty! That was exactly what I needed!