How to use vba to write a program to manage a lot of user data

And can accept different format of the data, and simple and clear?