Hi, I am looking to automate my stock keep as best as possible with excel, I have a stock list already but it is taking too long to manage.
Please help me solve the following problems:

I want to add PDF info to excel documents but columns seem to be seperated by ?
How can I change it, by function or file format so it can be copied properly into excel?

How can I use functions and formulas over multiple sheets?

I am looking for a quick sort mechanism, how can I have a button at the top to quick sort a column?

Using Ebay etc I can download a csv results of what has sold, how could I add this data and have it so it automatically changes stock amounts?
(just general example is fine)

Sorry it is a bit much, just easier to go through all my problems in one go.
Thank you for any help you can provide.