Sort referenced cells by cell value, not content

I have some textual data in a Calc spreadsheet in Sheet1. It is referenced on another sheet.

Having re-ordered the data on Sheet1, the sort order on the other sheet now looks something like this:


When I try to use the Data > Sort options, it will only offer me an alphabetical sort of the content, NOT a sort on the cell numbers (A1, A2, A3, etc.).

Question: Is there a way to make Calc sort these cells on the value of the cell number, rather than an alpha sort of the referenced content? I live in hope!

I have looked at these Q&As without working out my question, so perhaps I’m missing something:

Let’s assume you currently have only one column on Sheet 2. My suggestion would be to add a column to Sheet 2 that allows you to specify the desired order for the cells in question – then perform the sort for both columns on Sheet 2 based on the “Order” column.

Hope this helps.

Please click the check mark next to the response you believe best answers your question.