Applying Macros to Selections only.

Hi,

I'm fairly new (and self-taught -.-) to VB programming, and had previously only used Macros for "easy" stuff like doing the same Math function over and over again, making things colourful etc.

I have massive amounts of Data coming in from a scientific machine now, which I then transfer to txt files, which I read into excel (which works fine).
I've now written a macro that neatens it up, and deletes columns/rows I don't need.
However, I can only write it to work for one batch of data at a time, since the data sets are slightly different (I have macros for the different kinds). As the macros however involve cutting cells/columns, I can't currently read all the data sets in at once, but need to copy them in one by one, the copy the resultant cells out into another spreadsheet, and so on, which is much better than the practice people here have been applying before (copying every data by hand typing them into the appropriate cells).
Is there a way to only apply a Macro to a given selected range of cells? That way I could select the data batches one by one and apply the macros, after inserting all of them in one go to excel.

Thanks for your help!
Eli

TL;DR: Is there a way to get Macros to only work in a selected area of cells?

Here's a representation of what I'm doing - the colourful bit is what it looks like when the macros are done, and the rest is what my input would normally look like.
I've named things random letters and numbers, because I didn't want my actual data/topic on the internet at this stage, hope that's okay. As you can see, it cuts columns out, and I was planning to just manually select a dataset at a time, then run my macros on the selections one after the other, so at the end I would end up with everything cut to what I need and color-coded. Is this possible?

Thanks for the help, EliElinah1.xlsm

Thanks, Arkadi!

unfortunately, I am removing entire columns at the moment, which would then mess up the dataset below it. As the datasets are slightly different from each other however (about 3-4 "general" options), I'd like to have it as a seperate process for each dataset, so I can select individually which macro to apply.

Eli