Is it possible to create a macro for pivot table

Actually while doing reporting i have to create pivot table evevry day for same kind of data,all pivot table and data are in same work book but in different sheet by date wise, is it possible to create a macro so that i can use it in creating pivot table?