Is it possible to have autocomplete based on other entires from other sheets?

i have a few sheets in my Calc file with client names (for every month). when i add new sheet for a new month i fill it with my clients names, some of them were used on earlier sheets. i’d like autocomplete to predict names from other months.

You can use validation from Data → Validation, select a range as source and make sure to disable the error message if the value does not match.