Dynamic selections Excel

Hello friends, could you help me? I would like to know if you have a video or tutorial in which you teach how to configure excel to extract data from a cell for example A8 but we do not know which end it can be A12 or A34 but it always starts in the same cell. I understand that it is a dynamic selections