Autocomplete between seperate worksheets.

[Don Gursky]

Is there any possible way to use autocomplete between worksheets without copying the worksheets? I want to use one worksheet for the beginning of the week, and then each day after use a new worksheet, but use autocomplete between them.